XPT to SAS datasets
in [SAS]
|
From: Al on 21 May 2010 10:46 HI All: I have all the datasets stored in .XPT format in a library .. how can I convert them to SAS Datasets .. I know how to do it when single dataset is present .. On my machine I have SAS Base product , SAS/Stat and SAS/Access interface to ODBC Any suggestions Thanks in advance
From: Dav Vandenbroucke on 21 May 2010 16:51 On Fri, 21 May 2010 07:46:30 -0700 (PDT), Al <ali6058(a)gmail.com> wrote: >I have all the datasets stored in .XPT format in a library .. how >can I convert them to SAS Datasets .. I know how to do it when single >dataset is present .. >On my machine I have SAS Base product , SAS/Stat and SAS/Access >interface to ODBC It's pretty easy: libname outlib "out directory goes here"; libname inlib xport "directory stuff/filename.xpt"; proc copy in=inlib out=outlib; run; Dav Vandenbroucke davanden at cox dot net
From: Al on 23 May 2010 13:23 On May 21, 3:51 pm, Dav Vandenbroucke <dav_and_frances_vandenbrou...(a)compuserve.com> wrote: > On Fri, 21 May 2010 07:46:30 -0700 (PDT), Al <ali6...(a)gmail.com> > wrote: > > >I have all the datasets stored in .XPT format in a library .. how > >can I convert them to SAS Datasets .. I know how to do it when single > >dataset is present .. > >On my machine I have SAS Base product , SAS/Stat and SAS/Access > >interface to ODBC > > It's pretty easy: > > libname outlib "out directory goes here"; > libname inlib xport "directory stuff/filename.xpt"; > proc copy in=inlib out=outlib; > run; > > Dav Vandenbroucke > davanden at cox dot net Dear All; This is the error i get when i use the above code ... can any one help ... Thanks NOTE: Input library INLIB is sequential. ERROR: File is probably a cport file. XPORT engine unable to read file created by proc cport. Please use proc cimport to convert this file to native format. NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE COPY used (Total process time): real time 0.03 seconds cpu time 0.00 seconds NOTE: The SAS System stopped processing this step because of errors.
From: Tom Abernathy on 23 May 2010 13:47 SAS has two methods for exporting data. The XPORT libname engine (also known as V5 transport format) and the CPORT/CIMPORT procs. To use the CIMPORT proc the syntax is: libname out '<where you want to write the datasets>'; proc cimport infile='xxxx.xpt' lib=out ; run; An advantage of the CPORT format is that it supports newer datasets with long variable names and long character variables and also catalogs and other non-dataset members. A disadvantage is that it can be picky about which flavor of SAS you are using the write/read the transport file. On May 23, 1:23 pm, Al <ali6...(a)gmail.com> wrote: > On May 21, 3:51 pm, Dav Vandenbroucke > <dav_and_frances_vandenbrou...(a)compuserve.com> wrote: > > On Fri, 21 May 2010 07:46:30 -0700 (PDT), Al <ali6...(a)gmail.com> > > wrote: > > > >I have all the datasets stored in .XPT format in a library .. how > > >can I convert them to SAS Datasets .. I know how to do it when single > > >dataset is present .. > > >On my machine I have SAS Base product , SAS/Stat and SAS/Access > > >interface to ODBC > > > It's pretty easy: > > > libname outlib "out directory goes here"; > > libname inlib xport "directory stuff/filename.xpt"; > > proc copy in=inlib out=outlib; > > run; > > > Dav Vandenbroucke > > davanden at cox dot net > > Dear All; > > This is the error i get when i use the above code ... can any one > help ... Thanks > > NOTE: Input library INLIB is sequential. > ERROR: File is probably a cport file. XPORT engine unable to read file > created by proc cport. Please > use proc cimport to convert this file to native format. > NOTE: Statements not processed because of errors noted above. > NOTE: PROCEDURE COPY used (Total process time): > real time 0.03 seconds > cpu time 0.00 seconds > > NOTE: The SAS System stopped processing this step because of errors.
|
Pages: 1 Prev: WITH (NOLOCK) in Proc SQL Next: siebel Product Confirgurator -- Atlanta GA -- 10+ Months |