%sas2xl macro

fredee1_labcorp — Wed, 10 Oct 2007 15:50:03 GMT

Does anyone have the source code for David Brown's %sas2xl SAS macro that I can have? David presented this macro at Sugi 30 (paper 092-30) "%sas2xl: A Flexible SAS® Macro That Uses Tagsets to Produce Complex, Multi-Tab Excel Spreadsheets with Custom Formatting"

Re: %sas2xl macro

Cynthia_sas — Wed, 10 Oct 2007 20:00:01 GMT

Hi:
You might try contacting the author for the macro code. Or, consider using the TAGSETS.EXCELXP destination -- which has a lot of the functionality mentioned in his paper:
[pre]
ods tagsets.excelxp file='somesheets.xls' style=sasweb;

proc print data=sashelp.class;
run;

proc means data=sashelp.class min mean max;
var age height;
run;

ods tagsets.excelxp close;
[/pre]

You should then get 2 worksheets. One for each procedure. You can specify a different point for making different sheets (such as every table, every BY group, every output object, etc). TAGSETS.EXCELXP is self documenting in the latest versions and has ways for you to specify many enhancements to the spreadsheet.

Check with the ODS MARKUP site for more information:
http://support.sas.com/rnd/base/topics/odsmarkup/

cynthia

topic %sas2xl macro in ODS and Base Reporting

%sas2xl macro

Re: %sas2xl macro