Date:         Fri, 22 Aug 2003 17:02:03 +0200
Reply-To:     "Groeneveld, Jim" <jim.groeneveld@VITATRON.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Groeneveld, Jim" <jim.groeneveld@VITATRON.COM>
Subject:      Re: Extracting SAS variables with DBMSCopy
Comments: To: Tony <Todai77@HOTMAIL.COM>
Content-Type: text/plain; charset="iso-8859-1"

Hi Tony,

Not directly an answer to your Q, but DBMS/copy has several bugfixes; at least there is a version 7.0.5, which you could request as a legal owner of the lower version.

Regards - Jim.

Y. (Jim) Groeneveld MSc
Biostatistician Science Group
Vitatron B.V.
Meander 1051
6825 MJ Arnhem
The Netherlands
Phone: +31/0 26 376 7365
Jim_NO_Groeneveld@Vitatron_SPAM_com
(replace _NO_ and _SPAM_ by dots)

-----Original Message-----
From: Tony [mailto:Todai77@HOTMAIL.COM]
Sent: Friday, August 22, 2003 16:45
To: SAS-L@LISTSERV.UGA.EDU
Subject: Extracting SAS variables with DBMSCopy


Hi Everyone,

I am currently using DBMSCopy v. 7.0.1 to create SAS datasets from
pipe-delimited files.  I was wondering if it is possible to take a
blank SAS dataset and extract the variables and formats to create the
.dct and .prg files.  For example, if someone sent me a SAS dataset of
how they wanted that particular dataset to look like, can I use
DBMSCopy to create the .dct and .prg files so I can create a dataset
to replicate what they sent?  Any kind of help would be greatly
appreciated.  Thanks.

-Tony