The SAS Output Delivery System and reporting techniques

tagsets.tableeditor

Reply
New User
Posts: 1

tagsets.tableeditor

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

 

SAS Super FREQ
Posts: 8,721

Re: tagsets.tableeditor

Hi:
I would recommend working with Tech Support on a question like this.
cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 290 views
  • 0 likes
  • 2 in conversation