I decided to stop while I am ahead. My goal is to create a workbook that has a few mulitple pivot tables and also format the numbers. When I attempt the process for formating, the data part is blank. I do not get the mulitple worksheets. I am new to this approach so I am sure that I missed something.
Here is my snippet for the code:
filename temp url
'http://support.sas.com/rnd/base/ods/odsmarkup/tableeditor/tableeditor.tpl';
%include temp;
ods tagsets.tableeditor file="&path\enroll.html"
options(
pivot_series="yes"
button_text = "PivotTable"
AUTO_EXCEL="Yes"
pivotpage = "county_nm,race_desc | county_nm,race_desc | county_nm,race_desc"
pivotrow = "PROGRAM_AREA_DESC | CURRICULUM_NM | DEGREE_PURSUED"
pivotcol = "reporting_term,gender_code | reporting_term,gender_code | reporting_term,gender_code"
pivotdata = "student_cnt | studednt_cnt | student_cnt"
pivotdata_stats = "sum | sum | sum"
/*pivotdata_fmt="#,###"*/
excel_save_file="&path\enroll.xls"
/*SHEET_NAME="Program Area"*/);
proc print data=enroll noobs;
run;
ods tagsets.tableeditor close;
... View more
