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.

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;

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;