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>
Organization: http://groups.google.com
Subject:      Re: outputting multiple sas files to multiple worksheets
Comments: To: sas-l@uga.edu
In-Reply-To:  <20050929183736.18364.qmail@web80001.mail.yahoo.com>
Content-Type: text/plain; charset="iso-8859-1"

David,

1.) Yes
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.
3.) No.

Toby Dunn


People,
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;
run;
libname xlcopy;
quit;


  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 ?


Thanks
Dave


Dave Fickbohm
Use Technology to the Fullest
1250 45th st suite 200
Emeryville, CA, 94608
510 594 4151 voice