Paradox DB Files

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.

• Export a SAS Data Set to a Paradox DB File

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

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

• Import a SAS Data Set from a Paradox DB File

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

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

Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.