LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (September 2005, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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 ;

Back to: Top of message | Previous page | Main SAS-L page