File Format-Specific Reference for the IMPORT and EXPORT Procedures

Paradox DB File Formats

All versions of Paradox under Linux, UNIX, and Microsoft Windows are supported. Paradox files have a .db file extension. Paradox supports missing values. It does not have variables or value labels.

If a memo file with the same filename but with an .db extension exists, the memo text on that file is also read. The memo file is scanned to determine how many lines comprise the largest individual memo and the lengths of the longest lines. The driver then splits the memos into one variable per memo line. Memo support is read-only.

Example 1: EXPORT a SAS Data Set to a Paradox DB File

This example exports the SAS data set, SDF.CUSTOMER, to the Paradox DB file, customer.db, on a local system.

LIBNAME SDF "&sasdir";
PROC EXPORT DATA=SDF.CUSTOMER
            FILE="&tmpdir.customer.db"
            DBMS=DB REPLACE;
RUN;

Example 2: IMPORT a SAS Data Set from a Paradox DB File

This example imports the SAS data set, WORK.CUSTOMER, from the Paradox DB file, customer.db, on a local system.

PROC IMPORT OUT=WORK.CUSTOMER
            FILE="&tmpdir.customer.db"
            DBMS=DB REPLACE;
RUN;

Top of Page