Date:         Mon, 22 Oct 2007 21:01:34 -0500
Reply-To:     "data _null_," <datanull@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "data _null_," <datanull@GMAIL.COM>
Subject:      Re: How to convert all the xpt files in a folder to sas datasets
Comments: To: Joe Whitehurst <joewhitehurst@gmail.com>
In-Reply-To:  <129a50e0710221631i1c9d7df0gde8dfabe2521370b@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

I don't think CIMPORT works on files created with the XPORT engine.

On 10/22/07, Joe Whitehurst <joewhitehurst@gmail.com> wrote:
> 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
> > >
> > >
> >
>