Date: Mon, 22 Oct 2007 19:31:08 -0400
Reply-To: Joe Whitehurst <joewhitehurst@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Joe Whitehurst <joewhitehurst@GMAIL.COM>
Subject: Re: How to convert all the xpt files in a folder to sas datasets
In-Reply-To: <2C6B65AAC3623140922DE580669C456A03B7A26B@LTA3VS001.ees.hhs.gov>
Content-Type: text/plain; charset=ISO-8859-1
Albus, close Friend et al,
Why not use PROC CIMPORT? Am I missing something again?
Joe
On 10/22/07, Fehd, Ronald J. (CDC/CCHIS/NCPHI) <rjf2@cdc.gov> wrote:
>
> Subject: Re: how read *.xpt?
>
> information: proc copy xpt files to a libref
>
> http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0704B&L=sas-l&P=15209
>
> Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov
>
> > -----Original Message-----
> > From: owner-sas-l@listserv.uga.edu
> > [mailto:owner-sas-l@listserv.uga.edu] On Behalf Of SAS_learner
> > Sent: Monday, October 22, 2007 5:01 PM
> > To: SAS(r) Discussion
> > Subject: How to convert all the xpt files in a folder to sas datasets
> >
> > %Macro ds(ds ) ;
> > Libname Raw_xpt xport "Z:\MNTX\MNTX3301\Phase
> > Forward\SDTM\Draft_17_MNTX3301_Prod\&ds..xpt" access = readonly ;
> > Libname Raw_sets "Z:\Develop\data" ;
> > data &ds ;
> > set raw_xpt.&ds;
> > Run;
> > %Mend ;
> > %ds(ae) ;
> > %ds(am) ;
> > '
> > '
> > '
> > I know this might have been done before by someone I need to
> > get the List of all the datasets in the Folder where .XPT
> > files are located and change them to sas datasets, I am using
> > above code and it is doing what I need to do, but only thing
> > thing is I need to Physically supply List of all the DCM's
> > names to macro %ds but I do want to do that. I tried to pick
> > list of all he datasets using Proc Sql ; select memname into
> > : vname separated by " " from dictionary.columns ; Quit ;
> > but I do not know how to use that List to make Individual
> > datasets ?? Any Ideas
> >
> > thanks
> >
> >
>
| 
