[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: Export SAS Datasets to multiple workbooks of excel
From:       Rivo Ramamonjy <rivo.ramamonjy () TRICAST-GROUP ! COM>
Date:       2009-03-31 13:49:06
Message-ID: 5786CEA5FCADDD44AD5F29A5145573B1028D874A () fr-th-ex02 ! colibri ! vpn
[Download RAW message or body]

You may use ODS Tagsets.ExcelXP.
However, be aware of some disadvantages :
1) the resulting files may be quite large because they are in a verbose uncompressed \
XML format. 2) Some expressions may be (as usual!) wrongly presented when open in \
Excel. Example : the string "05-10" which would represent, say, age interval from 5 \
to 10,  may appear as "May-10" or "October-5"

Here is a simple example to create a workbook with one worksheet for each country.

Proc sort data=sashelp.prdsale out=work.prdsale;
   By country;
   Run;

ODS Tagsets.ExcelXP file="/dir/workbook.xls" options(SHEET_INTERVAL='BYGROUP');

   Proc print data=work.prdsale label noobs;
        By country;
        title;
        Run;
ODS tagsets.ExcelXP close;

Rivo.

-----Message d'origine-----
De : SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] De la part de Shailesh
Envoyé : mardi 31 mars 2009 15:07
À : SAS-L@LISTSERV.UGA.EDU
Objet : Export SAS Datasets to multiple workbooks of excel

I need to update Excel workbooks ( say 50 worksheets in number) from
sas datasets . I do not have PC SAS and work on UNIX sas. There is a
limitation that I need the data exactly the way it is in SAS and
Should get SAS Labels in output.

Appreciate any help on this.
Regards,


[prev in list] [next in list] [prev in thread] [next in thread]