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";
... View more