TABLE EDITOR AND ACTIVE X WARNING SUPPRESSION

[LB]

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;

[Reeza]

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

[Cynthia_sas]

Hi:

  I believe this is a question for Tech Support.

cynthia

[LB]

Thanks Cynthia.

Lawrence