Date:         Tue, 6 Oct 2009 12:10:04 GMT
Reply-To:     Scott Bass <sas_l_739@SPAMMERSAREEVIL.YAHOO.COM.AU.REMOVETHIS>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Scott Bass <sas_l_739@SPAMMERSAREEVIL.YAHOO.COM.AU.REMOVETHIS>
Organization: BigPond Internet Services
Subject:      Re: ODS
Comments: To: sas-l@uga.edu

Try something like:

libname xl excel "c:\myexcelfile.xls";

libname mysas "your sas library";

proc copy in=mysas out=xl;
   select dataset1 dataset2;
run;


"Njabsburg" <njabulo.thomo@gmail.com> wrote in message
news:a6ace0a4-b386-440c-ad3f-a2ad46576ef2@g1g2000vbr.googlegroups.com...
> HI
>
> I need to create one spreadsheet with 2 sheet names from 2 different
> datasets(all most all the variables are the same) but as a new
> beginner to SAs i seem to be struggling please help
>
> Thanks