Date:         Wed, 21 Sep 2005 23:52:31 -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

Actually, you should have two more copies of the concatenation, but they
are native SAS data sets in the WORK library, not Excel worksheets, and
they overwrite two of your three inputs.

When you name multiple output data sets and multiple input data sets, there
is no correspondence established. Rather (in the absence of any selective
code), everything goes everwhere. Needless to say, such a structure is not
commonly used.

Why are you compartmentalizing your data? It makes things more complicated
than they might otherwise be.

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 ;