Paul, If you're running SAS 9.2, you can try PROC REPORT's new SPANROWS option: http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a002473620.htm#a003234341 -- David Kelley, SAS ... View more

How to automate the retrieval of the object names, i.e can [pre]proc document name; list / levels=all; [/pre] be sent to macro variables or tables so the process can be run in batch? Chris, try this: [pre] proc document name=temp(write); import data=sashelp.class to ^; run; ods output properties=properties; list/levels=all; run; quit; proc print data=properties; run; [/pre] -- David Kelley, SAS ... View more

The ExcelXP tagset generates a Microsoft-defined XML called SpreadsheetML that is compatible with Excel 2003. SpreadsheetML does not support images. -- David Kelley, SAS ... View more

There's an undocumented capability in 9.2 PROC DOCUMENT to import a text file. You could create an ODS document for the procedure results, import the SAS log file into the document, and then replay the ODS document to the ODS PDF destination. Example: [pre] ods listing close; ods document name=temp(write); proc printto log="SAS.LOG"; run; proc tabulate data=sashelp.class; class sex age; table sex,age; run; proc printto; run; ods document close; proc document name=temp; import textfile="SAS.LOG" to ^; ods pdf file="out.pdf" notoc; replay; run; quit; ods pdf close; ods listing; [/pre] -- David Kelley, SAS ... View more

Andre, This problem was previously reported to Tech Support. We in R&D have made a fix that will be available in a future release. -- David Kelley, SAS ... View more

I believe that you need to check your ODS PATH settings. ODS PATH needs to define a writable template itemstore so that PROC TEMPLATE can store your template definition. Typically the first itemstore in the ODS PATH is SASUSER.TEMPLAT, and typically it's writable. You can check the ODS PATH by executing: [pre] ods path show; [/pre] -- David Kelley, SAS ... View more

Try this: [pre] define style styles.dashboard; [/pre] instead of: [pre] define style dashboard / store=styles; [/pre] -- David Kelley, SAS ... View more

A problem using FREQ crosstabs with the ExcelXP tagset in 9.2 has been reported to Technical Support and verified by R&D. We're working on a solution. -- David Kelley, SAS ... View more

Chris, Selection/exclusion lists reset at proc boundaries by default. Try putting the ODS PDF EXCLUDE statement immediately before the PROC SQL statement. -- David Kelley, SAS ... View more

Ed, If you continue to have trouble getting the desired output, I recommend contacting Technical Support. Click on the "Contact Us" link at the bottom of the forum web page. -- David Kelley, SAS ... View more

Bart, I recommend contacting Technical Support. To do that, click "Contact Us" at the bottom of the forum web page. -- David Kelley, SAS ... View more

Bart, ODS TEXT= is new to SAS 9.2: http://support.sas.com/rnd/base/new92/92odsmore.html#odstext SAS 9.1 has destination-specific TEXT=, e.g.: ods pdf file="out.pdf" text="Hello World!'; ods html file="out.html" text="Hello World!"; -- David Kelley, SAS ... View more

Bart, You could try replacing the TITLE statement with and ODS TEXT= statement. -- David Kelley, SAS ... View more

Ed, I recommend checking with SAS Technical Support. You ought to be able to get the desired behavior with: ODS DOCUMENT and PROC DOCUMENT ODS PDF COLUMNS=2 or ODS LAYOUT -- David Kelley, SAS ... View more