| Date: | Thu, 22 Sep 2005 20:57:41 -0400 |
|---|
| Reply-To: | "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM> |
|---|
| Subject: | Re: Outputting multiple SAS files to multiple worksheets - how to
label the worksheets separately |
|---|
Since you are just using DATA steps to transcribe data, try PROC DATASETS
instead.
On Wed, 21 Sep 2005 14:20:35 -0400, Hari Nath <hari_s_nath@YAHOO.COM> wrote:
>Thanks for pointing out my mistake. But i was trying to create a loop for
>different datasets OUTALPHA OUTBETA OUTGAMMA and so on. SAS gives me an
>excel output with *only one worksheet OUTALPHA* (but it has cumulative
>output, all that belongs to other datasets OUTBETA OUTGAMMA ....). Is there
>anything wrong with the loop i have. Please let me know that.
>Thanks
>
>
>LIBNAME X1 odbc noprompt="DRIVER=Microsoft Excel Driver (*.xls);
>ReadOnly=0;DBQ=R:\sts\RESULTS-ANAL1\ANAL1.XLS;";
>
>%LET Z = OUTALPHA OUTBETA OUTGAMMA ;
>DATA X1.&Z ;
> SET &Z ;
>RUN ;
>LIBNAME X1 ;
| 
