The format statement won't work here - you will  need to include the Excel formatting options in the ODS style options of your variables.   Try: var Target / style={tagattr='format:0.0%'} style(header) = vertical_header {foreground = black background = #ccccff} ; var Pct_Touched Pct_Enrolled pct_part / style={tagattr='format:0.0%'} style(header) = vertical_header {foreground = black background = #ccff99} ;   Note you must have the "style" option before the "style(header)" option..   There are some excellent ODS EXCELXP whitepapers out there: ODS ExcelXP: Tag Attr Is It! Using and Understanding the TAGATTR= Style Attribute with the ExcelXP Tagset Eric Gebhart, SAS Institute Inc., Cary, NC Don’t Gamble with Your Output: How to Use Microsoft Formats with ODS Cynthia L. Zender, SAS Institute, Inc., Cary, NC, USA Creating Stylish Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS® Vincent DelGobbo, SAS Institute Inc., Cary, NC Multi-sheet Workbooks from SAS ® data using the ODS ExcelXP tagset or Another Way to EXCEL using SAS Cynthia A. Stetz, Bank of America Merrill Lynch, Hopewell NJ SAS to Excel with ExcelXP Tagset Mahipal Vanam, Kiran Karidi and Sridhar Dodlapati So it's worth doing a little research to get fully informed (whereas the Discussions can often be a one-off answer to a one-off question).   Best best is to go to Lex Jansen's website and search for ExcelXP.   There's a Focus Area on ExcelXP tagsets in the support.sas.com site.   .. and keep an eye on anything @ChrisHemedinger posts on the subject in his SasDummy blog.   Hope this helps. ... View more

Sheeba,   SAS recommends the DI Fast Track training course as one method to prepare for DI Certification (and as a SAS Trainer, I would concur with that recommendation, although it's not cheap - depends on whether you'd be paying for it, or your employer)   So: Maybe do the training course, or; At least study the training course agenda (on the support.sas.com website), and use it as a "shopping list" of what you need to know, and what you need to study more..   Good luck!   Regards, Andrew. ... View more

Unless you're playing around with some advanced SAS options, when you create a table without a library reference, the default location for the newly created table is the WORK library.   So the following two statements are effectively identical:   data EMPDUP; set EMWS1.Ids3_DATA; MED_DUM = .; If MEDV >= 25 THEN MED_DUM = 1; run; data WORK.EMPDUP; set EMWS1.Ids3_DATA; MED_DUM = .; If MEDV >= 25 THEN MED_DUM = 1; run; As to where your table is PHYSICALLY located, run the following code to reveal the location of your WORK library location (Note: This location will most likely be different every time you run SAS)   %put %sysfunc(pathname(WORK)); ... View more