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 (June 2006, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 30 Jun 2006 11:31:39 -0400
Reply-To:   Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Subject:   Re: Export multiple datasets into a single worksheet.

...maybe a idea: add 3 blank-obs to each dataset at the end (also numerics can be kind of blank with the option MISSING=" " and filled up by missing values..) then concatenate them all with PROC APPEND before exporting.

On Fri, 30 Jun 2006 08:23:03 -0700, naveen.badugu@GMAIL.COM wrote:

>I have multiple SAS datasets which i get on a weekly basis and are of >variable length >Example: >June1,June2....June7 >All these datasets have the same structure. > >I need to export all these datasets into a single excel worksheet tab. >The required output is as follows: > >June1 >(3 blank lines) >June2 >(3 blank lines) >June3 >. > >How can i do this dynamically through a sas macro.

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