ODS EXCEL wasn't around in 2007. Old questions popping up for everyone is an interesting side effect of the new forum layout but does allow for people to point out newer usages.. ... View more

Smart users will still be able to find out about Library A by submitting proc sql; describe view B.AnyViewToA; quit; ... View more

Is there a way to print out the individual press residuals?   Mary   PROC REG DATA = sashelp.class OUTEST = work.estimates ; MODEL weight = height age / PRESS ; RUN ; QUIT ; PROC PRINT LABEL NOOBS ; RUN ; ... View more

Peter, I do agree with you : having LAG work in any context would be really strange. That's why I was trying to use it in FCMP, expecting an error or warning message. But nothing came, except strange results. Moreover, when I run [pre] PROC FCMP LIST ; RUN ; QUIT ; [/pre] the Output shows : [pre] Listing of Variables used in the Program _N_ _ERROR_ _LIST_ _DELTA_ _DER_ _I_ The Program Lag Length is 0. [/pre] Does that mean that the "Lag length" can be tuned ? I didn't see any option about that. Maybe some SAS folk would have an answer. Thanks for your answers. Olivier ... View more

Thanks for your responses. %Sysfunc did the trick. I appreciate the help. ... View more

Change your ods statement to this. ODS TAGSETS.EXCELXP FILE="large.xls" OPTIONS(PAGES_FITWIDTH="2" FitToPage="YES") ; It would be nice if the FitToPage option would turn on if a FitWidth or Height were given, I will add that in a future release of the tagset. ... View more

Hi Olivier, Thanks for your explanation. You code even resolved the issue as post 22 where some column headings has on numeric and SAS imposes the 'F' in front. I also want to THANKS everyone for their input to this thread that help me to resolve my problem. Regards Kwok ... View more

Thank you Scott. I was afraid I was missing something important, since there was no SAS Note in the Knowledge Database I could take trace of. I'll wait for any circumvention or fix as it comes out. Olivier ... View more

Thank you for your response. Very much appreciated 🙂 ... View more

Thank you both Wayne & Cynthia for explanations and solutions to solve my problem. Wayne, I've tested something with raw RTF, and this short version of your code seems to be enough (it allows me to leave the CONTENTS options and prevents from generating the content tables by myself) : [pre] ODS RTF FILE = "c:\temp\good.doc" CONTENTS BODYTITLE ; ODS ESCAPECHAR = "^" ; TITLE1 "^R'{\page}'" ; PROC PRINT DATA = sashelp.class ; RUN ; TITLE ; ODS RTF CLOSE ; [/pre] And as usual, I'll wait for 9.2 impatiently. Regards, Olivier ... View more

Thank you Cynthia : it does work fine with HTML3. I was sure when I posted this question that you will answer saying that proc Report does the job perfectly 🙂 So I didn't even bother to test the Report solution, being sure you would do it for me... Thanks a lot. I'm waiting for an update in the HTML4 tagset to solve the problem... Olivier ... View more

Thanks Cynthia. Your comment seems to prove this is all normal stuff : stick to the Printer family if you want something ready-to-print, and otherwise prepare yourself to include a little extra work on your file if you want it to be printed in a special way. I found out on a forum (http://www.tek-tips.com/viewthread.cfm?qid=1178234&page=1) some information about values of the PaperSizeIndex tag : value 1 (as written by ODS TAGSETS.EXCELXP) stands for LETTER, whereas 9 is for A4. The complete list of values is[pre] Paper Size Table Index Paper type Paper size ---------------------------------------------------- 0 Undefined 1 Letter 8 1/2" x 11" 2 Letter small 8 1/2" x 11" 3 Tabloid 11" x 17" 4 Ledger 17" x 11" 5 Legal 8 1/2" x 14" 6 Statement 5 1/2" x 8 1/2" 7 Executive 7 1/4" x 10 1/2" 8 A3 297mm x 420mm 9 A4 210mm x 297mm 10 A4 small 210mm x 297mm 11 A5 148mm x 210mm 12 B4 250mm x 354mm 13 B5 182mm x 257mm 14 Folio 8 1/2" x 13" 15 Quarto 215mm x 275mm 16 10" x 14" 17 11" x 17" 18 Note 8 1/2" x 11" 19 #9 Envelope 3 7/8" x 8 7/8" 20 #10 Envelope 4 1/8" x 9 1/2" 21 #11 Envelope 4 1/2" x 10 3/8" 22 #12 Envelope 4 3/4" x 11" 23 #14 Envelope 5" x 11 1/2" 24 C Sheet 17" x 22" 25 D Sheet 22" x 34" 26 E Sheet 34" x 44" 27 DL Envelope 110mm x 220mm 28 C5 Envelope 162mm x 229mm 29 C3 Envelope 324mm x 458mm 30 C4 Envelope 229mm x 324mm 31 C6 Envelope 114mm x 162mm 32 C65 Envelope 114mm x 229mm 33 B4 Envelope 250mm x 353mm 34 B5 Envelope 176mm x 250mm 35 B6 Envelope 125mm x 176mm 36 Italy Envelope 110mm x 230mm 37 Monarch Envelope 3 7/8" x 7 1/2" 38 6 3/4 Envelope 3 5/8" x 6 1/2" 39 US Standard Fanfold 14 7/8" x 11" 40 German Std. Fanfold 8 1/2" x 12" 41 German Legal Fanfold 8 1/2" x 13" [/pre] So I guess I must modify my Tagset by using Proc Template, adding some kind of option or other. PS : downloading the latest set of tagsets, the PAPERSIZE option is now taken into account. My dear thanks to all the ODS people who thought about it. ... View more