I’m creating several pivot table reports using Chevell Parker’s SAS Global Forum 2010 paper,
http://support.sas.com/resources/papers/proceedings10/003-2010.pdf.
My past history with leading zeros and tagsets doesn’t seem to be working this time.
I’ve tried the following within in my PROC PRINT, but it isn’t working.
var char_lead_zero / style(data)={tagattr="format:@"};
My current code follows my signature. The number_format, within the ODS statement, didn’t work either. I’m using SAS 9.13 SP 4.
TIA,
Kim LeBouton
data test;
input char_lead_zero $5. x year;
datalines;
01234 10 1999
02345 15 2000
12345 20 2001
;
run;
ods tagsets.tableeditor file="%sysfunc(getoption(work))\temp.html"
options(
/*button_text="Create PivotTable"*/
auto_excel="yes"
excel_open="yes"
pivotrow="char_lead_zero"
pivotcol="year"
pivotdata="x"
sheet_name="Test by Kim"
number_format="@"
excel_save_file="c:\\temp.xls"
quit="yes");
proc print data=work.test;
run;
ods tagsets.tableeditor close;