|
Toby wrote:
> Steve,
>
> I am not totally sure what Howard is talking about when he mentioned
> using proc datasets.
Something like:
proc datasets library=sashelp;
libname xlcopy excel 'c:\temp\xl-lib.xls';
copy out=xlcopy memtype=data;
select class shoes retail;
run;
libname xlcopy;
quit;
> However, all you need to do is the following:
>
> data Alpha ;
> set sashelp.class ;
> run ;
>
> data Beta ;
> set sashelp.class ;
> run ;
>
>
> Libname X1 odbc noprompt="DRIVER=Microsoft Excel Driver (*.xls);
> ReadOnly=0;DBQ=C:\Documents and Settings\n898226x\Desktop\Test.xls;";
>
>
> data X1.Alpha1 ;
> set Alpha ;
> run ;
>
> data X1.Beta1 ;
> set Beta ;
> run ;
>
> Libname X1 ;[snip]
| 
