ODS and Base Reporting | Forum profile

Hi: Run your job with the sub-option for doc: ods tagsets.excelxp file='xxxx.xml' options(doc='Help'); and then look for the SHEET_INTERVAL sub-option. I believe that you can control whether a new tab starts by using that sub-option. In addition, if you want more control over printing of the ExcelXP spreadsheet from within Excel, this is a very useful paper: http://www.nesug.org/proceedings/nesug08/ap/ap06.pdf cynthia

Suggested Google advanced search argument for the SAS support http://support.sas.com/ website where you will find technical conference papers with examples as well as SAS-hosted documentation: proc report ods style color site:sas.com Scott Barry SBBWorks, Inc.

Hi Cynthia, Thanks for your response. I atlast know how to proceed on with this. I go by your suggestion of creating the excel in mainframe file system and then FTP to Windows. Or i am also thinking of sending it via email too. That will solve my requirement now. Moving to the next level, i want to know if its possible to run a VB Excel Macro using SAS? The VB Excel Macro i have, just formats the excel report. It will be simple if i am able...

Hi Cynthia, and thank you. As soon as I get approval, I'm buying the book The variable s defines what column(s) need highlighting in each row. The columns to highlight are different in each row of the report. All of that calculation is done inside of a DATA step, so the only thing I have to worry about is how to get PROC REPORT to translate the value of s and apply the formatting to the individual cell. I was thinking that I needed tempo...

Hi everyone! I have almost solved this problem... Using the ASCII code, you can press ALT+xxxx where xxxx is a four digits number and a wide list of different symbols can be shown. But it's obvious that it's a closed list of values, and I like to know if there is a "superscript option" or something similar to put whatever you want. Moreover, I have stopped using ODS RTF because sometimes the match between the output and...

Thank you both for the information. Sorry I'm fairly new to this forum and was not aware of the Archieve's being available, thanks again. Happy Holidays

You're reason, i've mooved the ods under the macro, but the proc freq das not work because of the "&" (table var1*var2*var3/nopercent......out = sasuser. & scholl); log: Apparent symbolic reference school not resolved. Please help me, i'am new sas user. Thank's a lot.

PROC PRINT DATA=ALL NOOBS label; VAR HLQ GBUSED; LABEL GBUSED="&SYSDATE"; Use the label option and macros inside single quotes don't resolve.

Thank you for your replies data _null_ and Cynthia. The ODS solution worked perfectly - thank you. I can see maybe I need to buy a book on ODS, have you a recommendation Cynthia ???

Hi Cynthia, Thanks heaps for your help. It worked Just if anyone need this piece of code... I got something like that : /********** Email To ***********************/ Filename Test Email To = 'ABC@mail.com' Type='Text/html' Subject = 'Report'; /***** Your html page starts here which will be view by the receipients *****/ ODS Markup Body = Test Style = SASWEB; Title 'This is my title on my html'; PUT...