Date: Thu, 29 Sep 2005 12:12:50 -0700
Reply-To: Toby <tobydunn@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Toby <tobydunn@HOTMAIL.COM>
Subject: Re: outputting multiple sas files to multiple worksheets
Content-Type: text/plain; charset="iso-8859-1"
2.) I know Howard used version 9 and I think that was the first time we
had Excel libname engine. So I believe you have to have version 9 or
higher to make this happen.
Yesterday this was discussed and I understand most of it. The code as
I understand it follows:
proc datasets lib = sashelp;
libname xlcopy excel "c:\temp\xl-lib.xls";
copy out=xlcopy memtype = data;
select class shoes retail;
I have a couple of questions
1 - I think this code is copying SAS files into excel?
2 - Is this sas ver9?
3 - Do we not have to export the data as csv or xls first ?
Use Technology to the Fullest
1250 45th st suite 200
Emeryville, CA, 94608
510 594 4151 voice