Date: Wed, 16 Jun 2010 14:47:57 -0400
Reply-To: Michael Raithel <michaelraithel@WESTAT.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Michael Raithel <michaelraithel@WESTAT.COM>
Subject: Re: How to read SAS version 6 dataset XX.ssd01 data in SAS 9?
Content-Type: text/plain; charset="us-ascii"
Lilly Peng posted the following:
> I am trying to convert a SAS V6 dataset xx.ssd01 to SAS V9 dataset
> using PC SAS version 9. However, SAS (version 9) tells me that the
> library which has XX. ssd01 is empty. Anyone here knows how to handle
> it? Thanks a lot!!
> libname adata v6 "C:\mydata";
> libname adata9 v9 "c:\newdata";
> proc copy in=adata out=adata9 memtype=data;
> 1131 libname adata v6 "C:\mydata";
> NOTE: Libname ADATA refers to the same physical library as SOURCE6.
> NOTE: Libref ADATA was successfully assigned as follows:
> Engine: V6
> Physical Name: C:\mydata
> 1132 libname adata9 v9 "c:\newdata";
> NOTE: Libname ADATA9 refers to the same physical library as TMP2.
> NOTE: Libref ADATA9 was successfully assigned as follows:
> Engine: V9
> Physical Name: c:\newdata
> 1133 proc copy in=adata out=adata9 memtype=data;
> 1134 run;
> WARNING: Input library ADATA is empty.
> NOTE: PROCEDURE COPY used (Total process time):
> real time 0.01 seconds
> cpu time 0.00 seconds
Lilly, I was going to make Joe's very suggestion of using a PROC CPORT/PROC CIMPORT sandwich, but see that it won't work for you. Drat!
Since you have SAS 9.2 which comes with SAS Enterprise Guide, you are in luck. Check out this tech support note:
So, you may be able to program SAS EG to open the data set and write it out to a format that you can use... e.g. CSV or, hey: SAS. Check it out!
Lilly, best of luck in all your SAS endeavors!
I hope that this suggestion proves helpful now, and in the future!
Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or applicability. People deciding to use information in this posting do so at their own risk.
Michael A. Raithel
"The man who wrote the book on performance"
Author: Tuning SAS Applications in the MVS Environment
Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition
Author: The Complete Guide to SAS Indexes
Probable impossibilities are to be preferred to improbable possibilities. - Aristotle