OK so I am fairly new to SAS EG- SO my question is that I see what is 'My folder' on SAS EG- How can I save to that?  I am looking to namely save passwords, etc etc so other users can't see them. Thanks Lawrence ... View more

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; ... View more

Hello all- Happy Friday- I have a couple of questions regarding the tagsets.tableeditor and output to Excel (and XML) Here is the basic code I have-It is simply summing the values of a numerator and denominator- ods tagsets.tableeditor file="temp.html"     options(                                sheet_name="HAP Rates"                 auto_excel="yes"                 excel_save_file="P:\example1.xlsx" quit="NO"                 pivotrow="fac_id"                 pivotdata="numer,den"                 pivotdata_stats="sum"                 PIVOTDATA_TOCOLUMNS="yes"                 /*pivotdata_caption="NUM,DEN"*/                 pivotpage = "month" ) ; Here are my questions- 1) Why does the pivotdata_caption option not work as it should-when I un-comment it out -It only gives me the first column and not the second. 2) Is there is a way to actually hide the underlying sheet (without manual intervention after the production.) 3) How can I color the headers for the columns? 4) How can I make sure that the underlying date format prints correctly (in Excel) 5) How can I actually save as an XML file, not just using the xml extension. I am sure that I will have more questions, but this is just a start. Thanks for your time. Lawrence ... View more

Hi all; I have a general question regarding MS Access in respects to deletion/update queries- When I attempt to delete multiple deletions or updates that are grouped (by a medical record number (mrn)  for example)-I cannot make one whole deletion query- It results in an error that results in a rollback of the data. Instead I must create a macro that cycles through every MRN. When you have 4,000 of them-this becomes a huge timer killer. Any suggestions on resolving this. Thank you. Lawrence ... View more

Hello all- I have the below statement in SAS 9.2 ODS PDF TEXT ="\S={leftmargin=.25in font_weight=bold font_size=1 color=&COLOR1 URL='#SCORE'} &FACID1=&RATE1 \S={leftmargin=.25in font_weight=bold font_size=1 color=&COLOR2 URL='#SCORE2'} &FACID2=&RATE2"; The macros vars convey the medical centers and their rates in color depending on below/above the target. The problem I am having is connecting to multiple pdf anchors within the report. Only the first URL anchor seems to take effect through the whole statement and the others are negated after-Is there a way to get around that if I want to keep this on the same line?  Also how do I change the borders to be rid of the blue border. Thanks Lawrence ... View more