Date:         Fri, 8 Jan 1999 07:30:18 -0500
Reply-To:     Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Subject:      Re: How to read PARADOX .DB files in SAS ?
Content-Type: text/plain; charset=US-ASCII

I have had success using Dynamic Data Exchange (DDE). Below is a SAS log providing an example.
 
Paradox 5 works with both Paradox (.db) and dBase (.dbf) file types. This is direct "native" support, not data export/import. If you can get .dbf files rather
than .db files, there will be more options on the SAS side.
 
> Date:    Wed, 6 Jan 1999 18:41:28 +0800
> From:    Wong Chin Pang Antonio <cpwong@SE.CUHK.EDU.HK>
> Subject: How to read PARADOX .DB files in SAS ?
> 
> Hi all,
> 
> I would like to read PARADOX 5.0 .DB files in the SAS system. Can
> someone tell how to do it ?
> 
> Thank you very much for your attention.
> 
> Regards,
> 
> Antonio
 
DATA step reading Paradox file via DDE:
 
   1       filename export94 dde 'PDOXWIN|d:\bembooks\pdox\census94.DB!_TABLE';
   2
   3       data export94; infile export94 dlm='09'x notab dsd missover;
   4       input recnum sitc $ x94:comma32.; drop recnum;
   5       x94 = x94/1000;
   6       run;
   
   NOTE: The infile EXPORT94 is:
         FILENAME=PDOXWIN|d:\bembooks\pdox\census94.DB!_TABLE,
         RECFM=V,LRECL=256
   
   NOTE: 3090 records were read from the infile EXPORT94.
         The minimum record length was 14.
         The maximum record length was 24.
   NOTE: The data set WORK.EXPORT94 has 3090 observations and 2 variables.
   NOTE: The DATA statement used 2.64 seconds.