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.