Hello! I am unable to get pivot_title and pivot_format options to work with pivot_series ="yes". Thanks in advance for any insights!
options noxsync noxwait;
ods tagsets.tableeditor file="E:\data1\users\asande26\Programs\Examples\ODS\tableeditor\scripts\PivotTable.js"
/* remember to escape the backslashes */
options(update_target="E:\\data1\\prod\\common\\mngr\\usr_mgmt\\usr_access_rptg\\output\\Dash_Users_test_save.xls" doc="help"
output_type="script"
pivot_series="yes"
sheet_name="DashUsage | DashUsage"
pivot_sheet_name="UsersbyDate | UsersbyGroup"
pivotrow="name | name"
pivotcol="request_date | group_name"
pivotdata="name | name"
pivot_format="medium6"
pivot_title="Dashboard Usage"
excel_save_file="E:\\data1\\prod\\common\\mngr\\usr_mgmt\\usr_access_rptg\\output\\Dash_save_test.xlsx"
file_format="xlsx"
open_excel="yes"
auto_excel="yes"
);
/* dummy output to trigger the file creation */
data _null_;
file print;
put "test";
run;
ods tagsets.tableeditor close;
/*execute java script*/
x "E:\data1\users\asande26\Programs\Examples\ODS\tableeditor\scripts\PivotTable.js";
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.