tagsets.tableeditor

[alisonATjhu]

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";

[Cynthia_sas]

Hi:
I would recommend working with Tech Support on a question like this.
cynthia