The SAS Output Delivery System and reporting techniques

%sas2xl macro

Reply
Learner
Posts: 1

%sas2xl macro

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"
SAS Super FREQ
Posts: 8,744

Re: %sas2xl macro

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
Ask a Question
Discussion stats
  • 1 reply
  • 120 views
  • 0 likes
  • 2 in conversation