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.
DATA step reading Paradox file via DDE:
1 filename export94 dde 'PDOXWIN|d:\bembooks\pdox\census94.DB!_TABLE';
3 data export94; infile export94 dlm='09'x notab dsd missover;
4 input recnum sitc $ x94:comma32.; drop recnum;
5 x94 = x94/1000;
NOTE: The infile EXPORT94 is:
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.