BookmarkSubscribeRSS Feed
LB
Quartz | Level 8 LB
Quartz | Level 8

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;

3 REPLIES 3
Reeza
Super User

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

Cynthia_sas
SAS Super FREQ

Hi:

  I believe this is a question for Tech Support.

cynthia

LB
Quartz | Level 8 LB
Quartz | Level 8

Thanks Cynthia.

Lawrence

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1091 views
  • 0 likes
  • 3 in conversation