The SAS Output Delivery System and reporting techniques

tagsets.tableeditor - unable to save the output file

Reply
Occasional Contributor
Posts: 15

tagsets.tableeditor - unable to save the output file

Hi,

 

I am using the below script for creating the excel pivot table. Can you please help for the below 2 issues

 

1) I am able to create the excel with the pivot, but I could not save the excel automatically. The excel opens and promts me to save.

    Error: Unable to set the Orientation property of the PivotField class

    Also I tried using excel_save_file option, before trying update_target

2) I need to suppress the sub totals and I want only the grand total


/* Create file to update */
ods tagsets.Excelxp file="c:\temp.xls" options(sheet_name="temp") ;
proc print data=fin_all;
run;
ods tagsets.Excelxp close;

/* update the file with a simple pivot table by creating a javascript file that we execute */
options xnowait noxsync;
ods noresults;
ods tagsets.tableeditor file="C:\temp.js"
options(output_type="script"
update_target="c:\\temp.xls"
sheet_name = "temp"

pivotrow="Name, ID, TGT_NOS"
PIVOTDATA_TOCOLUMNS="YES"
pivotpage="AREA, LOC_CD, LOCATIONNAME, product, ACTIVITY_DATE");
data _null_;
file print;
put "test";
run;
ods tagsets.tableeditor close;
/* execute Script file */
x "C:\temp.js";

 

Occasional Contributor
Posts: 15

Re: tagsets.tableeditor - unable to save the output file

Hi

 

I resolved the orientation error

 

Can anybody share your idea for resolving

1. To save the excel ouput file automatically?

2. To eliminate the sub totals

 

Thanks

Chandramohan

Post a Question
Discussion Stats
  • 1 reply
  • 250 views
  • 0 likes
  • 1 in conversation