Date:         Wed, 7 Jun 2006 20:02:51 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: export SAS data to multiple excel sheets
Comments: To: master2005_sas@YAHOO.COM

Mindy,

If you have SAS/Access to PC products, you can identify the worksheets.
E.g.,

PROC ACCESS DBMS=XLS | EXCEL;  CREATE libref.member-name.ACCESS | VIEW;
 UPDATE libref.member-name.ACCESS | VIEW;
 GETNAMES <=> YES | NO | Y | N;
 PATH= 'path-and-filename'<.XLS> '| <'>filename<'> | fileref;
 RANGE <=> <'>range-name<'> | 'range-address';
 SCANTYPE <=> YES | NO | Y | N | <number-of-rows>;
 SKIPROWS <=> number-of-rows-to-skip;
 WORKSHEET <=> worksheet-name;
 ASSIGN <=> YES | NO | Y | N ;
 DROP <'>column-identifier-1<'> <...<'>column-identifier-n<'>>;
 FORMAT <'>column-identifier-1<'> <=> SAS-format-name-1
<...<'>column-identifier-n<'> <=> SAS-format-name-n> ;
 LIST <ALL | VIEW | <'>column-identifier<'>> ;
 MIXED <=> YES | NO | Y | N;
 RENAME <'>column-identifier-1<'> <=> SAS-variable-name-1
<...<'>column-identifier-n<'> <=> SAS-variable-name-n> ;
 RESET ALL | <'>column-identifier-1<'> <...<'>column-identifier-n<'>> ;
 SELECT ALL | <'>column-identifier-1<'> <...<'>column-identifier-n<'>> ;
 SUBSET selection-criteria ;
 TYPE column-identifier-1 <=> C | N <... column-identifier-n <=> C | N>;
 UNIQUE <=> YES | NO | Y | N ;

RUN;

HTH,
Art
--------
On Wed, 7 Jun 2006 16:51:52 -0700, Mindy <master2005_sas@YAHOO.COM> wrote:

>Hey, guys,
>
>I am using SAS 8.2 under windows. And I have DBMS8.0 on my computer
>too. Does any one know how to export SAS data to multiple excek sheets?
>Any suggestions and articles are welcome.
>
>Thanks,
>Mindy