The SAS Output Delivery System and reporting techniques

ODS TAGSETS TABLEEDITOR - pivotpage

Reply
Contributor
Posts: 61

ODS TAGSETS TABLEEDITOR - pivotpage

I am using sas 9.4 and SAS EG 7.1.  I am trying to create a pivot with report filters but it is not working. I have successfully created a pivot that did not have a report filter so I know my code is good.  I have attached a copy of the error and javascript.

 

Is a new verions of tabset needed.  the one on the site is from 3/2015 which is the one I have.

 

Thanks,

 

here is my code:

 

filename temp "/ptr/rpl_cbpa/bpa/mor_data/uat/tagset/tableeditor.tpl";

%include temp;

 

ods tagsets.Tableeditor

path='/rpt/data/adhoc_rpts' file='issue_data.js'

options(output_type="script"

           update_target="C:\\Users\\cm55555\\Documents\\Issue_Data.xml"

           sheet_name="Issue_Data"

           pivot_sheet_name="Issue_Data_Pivot"

           pivotpage="OPEN_DT,CLOSE_DT,REOPEN_DT"

           pivotrow="LOB"

        pivotcol="MCA_TIER"

        pivotdata="ISSUE_ID_CH"

        pivotdata_stats="count"

           pivot_format="light16"

        

);

 

data _null_;

file print;

put "test";

run;

Post a Question
Discussion Stats
  • 0 replies
  • 245 views
  • 0 likes
  • 1 in conversation