In reply to prashanth.

Hi,

I am using the below code to generate the pivot on UNIX via JavaScript. However the option noxsync noxwait; both are invalid option and I am not able to see the final pivot an chart output. I am using SAS9.4 version on UNIX. Kindly let me know if I am missing anything. Thanks for the help!

options noxsync noxwait;
ods tagsets.tableeditor file="/apc/analyst/abdfc/temp/PivotChart.js"
/* remember to escape the backslashes */
options(update_target="/apc/analyst/abdfc/temp/temp.xlsx"
output_type="script"
sheet_name="shoe_report"
pivot_sheet_name="Profit Analysis Pivot"
pivotrow="region"
pivotcol="product"
pivotdata="sales"
pivotdata_fmt="$#,###"
pivot_title="Pivot Analysis for XXX"
pivot_format="light1"
pivotcharts="yes"
pivot_chart_name="Profit Analysis Charts"
chart_type="columnclustered"
);

/* dummy output to trigger the file creation */
data _null_;
file print;
put "test";
run;

ods tagsets.tableeditor close;

X '/apc/analyst/abdfc/temp/PivotChart.js';