Okay, I give, where is the complete documentation in Enterprise Guide 4.3 for SAS Rapid Predictive Modeler, as noted in http://support.sas.com/documentation/cdl/en/whatsnew/62580/HTML/default/viewer.htm#rpmwhatsnew902.htm? I did the electronic download in January and am running EG 4.3 (4.3.011182) Hot fix 14. I also was unable to find the "complete usage documentation" in Excel 2003.  Both Enterprise Guide 4.3 and Excel have documentation for Model Scoring, which is the other option under the Data Mining Task. TIA, Kim LeBouton ... View more

Has anyone been able to get the following example, http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html#multiple, to work with either SAS 9.13 or SAS 9.2 (TS2M3) and Excel 2003? Even after fixing the syntax error, Excel reports back that the spreadsheet has a serious error. TIA, Kim LeBouton ... View more

Yesterday, I noticed the subject line in the following page, http://support.sas.com/kb/25/536.html. Will there be any future cool tools that will convert DSGI to ODS? I've been following the ODS Report Writing Interface, but it isn't production yet either, http://support.sas.com/rnd/base/datastep/dsobject/index.html. I have an old (circa '98), very detailed report that used DSGI, since pre-ODS didn't meet the needs at the time. Of course, there were hours of coding involved to create the two page report. TIA, Kim LeBouton KJL Computing ... View more

Two questions that I believe are related to the ExcelXP tagset. 1) I have one of those really long legal titles that takes up row 5 of an Excel spreadsheet. I've mimicked the title below and the carriage returns that I need, but can't figure out how to obtain with SAS. 2) The title that is returned isn't half bad, although the client will object. When I open the spreadsheet, the title is partially hidden, and I need to do a manual fix. For that particular title, I almost need an Excel row height of 55. Any options that I've overlooked? TIA, Kim LeBouton %let title5="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz"; ods html close; ods tagsets.excelxp file='c:\test long titles.xls'; ods tagsets.excelxp options(embedded_titles='yes' gridlines='yes' autofit_height='yes'); ods tagsets.excelxp options(sheet_name='XXX XXXXX'); title j=center font='Century Gothic' height=8pt &title5; proc print data=sashelp.class; run; ods tagsets.excelxp close; ... View more

I’m creating several pivot table reports using Chevell Parker’s SAS Global Forum 2010 paper, http://support.sas.com/resources/papers/proceedings10/003-2010.pdf. My past history with leading zeros and tagsets doesn’t seem to be working this time. I’ve tried the following within in my PROC PRINT, but it isn’t working. var char_lead_zero / style(data)={tagattr="format:@"}; My current code follows my signature. The number_format, within the ODS statement, didn’t work either. I’m using SAS 9.13 SP 4. TIA, Kim LeBouton data test; input char_lead_zero $5. x year; datalines; 01234 10 1999 02345 15 2000 12345 20 2001 ; run; ods tagsets.tableeditor file="%sysfunc(getoption(work))\temp.html" options( /*button_text="Create PivotTable"*/ auto_excel="yes" excel_open="yes" pivotrow="char_lead_zero" pivotcol="year" pivotdata="x" sheet_name="Test by Kim" number_format="@" excel_save_file="c:\\temp.xls" quit="yes"); proc print data=work.test; run; ods tagsets.tableeditor close; ... View more

I apologize if this question/answer has been posted before. I tried to do a search of this Forum and could not find a similar question/answer. I have a very old PROC PRINT report that I’m branding, hopefully without a template change. I’ve tried the code following my signature, but with no luck. The Century Gothic font is applied to the title, header, and columns (a b c d e f). x & y retain the default template font. Is there a quick way to fix x & y? I recognize that I could rewrite it in PROC REPORT and get my desired output, without a template change. TIA, Kim LeBouton ods pdf file=’ .pdf’ notoc uniform; TITLE1 j=l font="Century Gothic" "&TITLe1"; TITLE2 j=l font="Century Gothic" "&TITLe2"; TITLE3 j=l font="Century Gothic" "&TITLe3. DETAIL"; TITLE4 j=l font="Century Gothic" "&TITL4"; PROC PRINT DATA=xxx N NOOBS SPLIT='*' style(HEADER)={font_face=' Century Gothic'} style(COLUMN)={font_face=' Century Gothic'} style(data)={font_face=' Century Gothic'} ; BY x y; ID x y; SUMBY y; PAGEBY x; VAR a b c d e f; Run; ods pdf close; ... View more

Using the “Writing a Customized Summary on Each Page” from http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a002473656.htm, how would I remove the box around the compute blocks and lines statements when writing a PDF file? I’m still using SAS 9.13. Using ODS markup, I know that the Style Element is NOTECONTENT: STYLE NoteContent / ; I attempted the following but it didn’t work: proc template; define style styles.nonotes; parent=styles.default; style NoteContent / frame=void rules=none ; end; run; As you can probably guess, I’m trying to create more than 10 footnotes and the border makes the report look weird. The code follows my signature. TIA, Kim LeBouton proc format /*library=proclib*/; value $sctrfmt 'se' = 'Southeast' 'ne' = 'Northeast' 'nw' = 'Northwest' 'sw' = 'Southwest'; value $mgrfmt '1' = 'Smith' '2' = 'Jones' '3' = 'Reveiz' '4' = 'Brown' '5' = 'Taylor' '6' = 'Adams' '7' = 'Alomar' '8' = 'Andrews' '9' = 'Pelfrey'; value $deptfmt 'np1' = 'Paper' 'np2' = 'Canned' 'p1' = 'Meat/Dairy' 'p2' = 'Produce'; run; data grocery; input Sector $ Manager $ Department $ Sales @@; datalines; se 1 np1 50 se 1 p1 100 se 1 np2 120 se 1 p2 80 se 2 np1 40 se 2 p1 300 se 2 np2 220 se 2 p2 70 nw 3 np1 60 nw 3 p1 600 nw 3 np2 420 nw 3 p2 30 nw 4 np1 45 nw 4 p1 250 nw 4 np2 230 nw 4 p2 73 nw 9 np1 45 nw 9 p1 205 nw 9 np2 420 nw 9 p2 76 sw 5 np1 53 sw 5 p1 130 sw 5 np2 120 sw 5 p2 50 sw 6 np1 40 sw 6 p1 350 sw 6 np2 225 sw 6 p2 80 ne 7 np1 90 ne 7 p1 190 ne 7 np2 420 ne 7 p2 86 ne 8 np1 200 ne 8 p1 300 ne 8 np2 420 ne 8 p2 125 ; run; /*libname proclib 'SAS-data-library';*/ options nodate pageno=1 /*linesize=64 pagesize=30 fmtsearch=(proclib)*/; ods listing close; ods html close; ods pdf file='c:\test to remove box'; proc report data=grocery nowd headline headskip; title 'Sales for Individual Stores'; column sector manager department sales Profit; define sector / group noprint; define manager / group noprint; define profit / computed format=dollar11.2; define sales / analysis sum format=dollar11.2; define department / group format=$deptfmt.; compute profit; if department='np1' or department='np2' then profit=0.4*sales.sum; else profit=0.25*sales.sum; endcomp; compute before _page_ / left; line sector $sctrfmt. ' Sector'; line 'Store managed by ' manager $mgrfmt.; line ' '; line ' '; line ' '; endcomp; break after manager / ol summarize page; compute after manager; length text $ 35; if sales.sum lt 500 then text='Sales are below the target region.'; else if sales.sum ge 500 and sales.sum lt 1000 then text='Sales are in the target region.'; else if sales.sum ge 1000 then text='Sales exceeded goal!'; line ' '; line text $35.; endcomp; run; ods pdf close; ... View more