The SAS Output Delivery System and reporting techniques

TABLE EDITOR AND ACTIVE X WARNING SUPPRESSION

Reply
Frequent Contributor
Frequent Contributor
Posts: 139

TABLE EDITOR AND ACTIVE X WARNING SUPPRESSION

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;

Super User
Posts: 19,822

Re: TABLE EDITOR AND ACTIVE X WARNING SUPPRESSION

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 Smiley Happy

SAS Super FREQ
Posts: 8,868

Re: TABLE EDITOR AND ACTIVE X WARNING SUPPRESSION

Hi:

  I believe this is a question for Tech Support.

cynthia

Frequent Contributor
Frequent Contributor
Posts: 139

Re: TABLE EDITOR AND ACTIVE X WARNING SUPPRESSION

Posted in reply to Cynthia_sas

Thanks Cynthia.

Lawrence

Ask a Question
Discussion stats
  • 3 replies
  • 522 views
  • 0 likes
  • 3 in conversation