Hello all-
IS there anyway to suppress the active X warning when I produce a pivot table using the table editor?
I am attempting to to include two pivot tables into the same worksheet.
So when when I run the first part of code-and even though I have the QUIT='YES' option included-
I still get the warning and I must save the file anyway.
So if i want to run the second part of the code below-then I have to run the first part, save the file, and then run the second part of the code.
I have tried disabling/enabling all the Active X commands in IE 9 but that does not seem to have an effect.
At the end of the day, what I really want to do is copy over a template and then update that document with both pivot tables.
Thanks
Lawrence
ods tagsets.tableeditor file="temp.html"
options(
sheet_name = "Not Permitted to Order"
auto_excel="yes"
excel_save_file="P:\&MO_REPORT._&MO_RE_YR._HR_TYPE_H.xls" QUIT="YES"
pivotrow="JOBTITLE,PROVIDER"
pivotdata="LABCOUNT,NOTKPHC"
pivotdata_caption="Lab Tests,Lab Tests not in XXX"
pivotdata_stats="sum,sum"
PIVOTDATA_TOCOLUMNS="yes"
pivot_format="medium9"
pivotpage = "PRIMDC,PRIFAC"
Delete_sheets="Not Permitted to Order") ;
proc print data=XP.HRLIST ;
where jobtitle ne 'CE - RN, EXTENDED ROLE' ;
LABEL PRIFAC='Med Facility';
LABEL PRIMDC='Med Center';;
run;
ods tagsets.tableeditor file="temp1.html"
options(
sheet_name = "RN Extended Role"
auto_excel="yes"
update_target="P:\&MO_REPORT._&MO_RE_YR._HR_TYPE_H.xls"
pivotrow="JOBTITLE,PROVIDER"
pivotdata="LABCOUNT,NOTKPHC"
pivotdata_caption="Lab Tests,Lab Tests not in XXX"
pivotdata_stats="sum,sum"
PIVOTDATA_TOCOLUMNS="yes"
pivot_format="medium9"
pivotpage = "PRIMDC,PRIFAC"
Delete_sheets="RN Extended Role") ;
proc print data=XP.HRLIST;
where jobtitle eq 'CE - RN, EXTENDED ROLE' ;run;
ods tagsets.tableeditor close;
Not answering your question, but honestly never found the table editor destination very useful.
I prefer to create my template manually, copy the template via x or sys exec, export out new SAS data to my copied template and refresh pivot table via DDE or VB if absolutely required. This requires BASE SAS and the ability to run DDE and X commands, but it works like a charm
Hi:
I believe this is a question for Tech Support.
cynthia
Thanks Cynthia.
Lawrence
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.