Hi Chevell,
a great tagset and works well with the basics.

I have a problem when adding the slicer option as the js scripts are missing an object on execution afterwards.
i tried to compare that with the microsoft docs for slicer object. is there maybe an error in the translation to the js code?

here the details:

options noxsync noxwait;
ods tagsets.tableeditor file="&out_dir.\PivotTable.js"
/* remember to escape the backslashes */
options(update_target="&out_dir_js.\\temp.xlsx" doc="help"
output_type="script"
sheet_name="shoe_report"
pivot_sheet_name="Profit Analysis"
pivot_slicer="region"
pivot_slicer_position="200,10,100,100"
pivotrow="subsidiary"
pivotcol="product"
pivotdata="sales"
pivotdata_fmt="$#,###"
pivot_format="light1"
pivot_title="Pivot Analysis for XXX"
excel_save_file="&out_dir_js.\\tempPivot.xlsx"
);

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

ods tagsets.tableeditor close;

HERE WHAT THE JS SAYS REGARDING THE SLICER:

var SlC = wb.SlicerCaches;
var region=SlC.Add2(pws.PivotTables(1),"REGION");
var temp_region=region.Slicers.Add(SlicerDestination="Profit Analysis");

HERE MICROSOFT DOC:

//.SlicerCaches.Add("AdventureWorks", _
//"[Customer].[Customer Geography]").Slicers.Add SlicerDestination:="Sheet2", _
//Level:="[Customer].[Customer Geography].[Country]", Caption:="Country"

Thanks in advance!