The SAS Output Delivery System and reporting techniques

ODS PDF/Excelxp simultaneous destinations

Accepted Solution Solved
Reply
Contributor
Posts: 51
Accepted Solution

ODS PDF/Excelxp simultaneous destinations

I wrote code to produce PDF reports (Ent. Guide 5.1, SAS 9.3) which works fine.  However as I am frequently asked for the same report in excel I would like the same proc print/proc report to simultaneously output to Excel (multiple destination ODS).   I attempted to introduce tagset.Excelxp steps within the existing code however I get "ERROR: Absolute layout is supported only for ODS PRINTER".    

Is what I'm attempting possible to achieve?


Example attached, ODS tagset statements are commented out.

(I realise that the tagsets-Excel method omits the charts from my example)


Thank

Attachment

Accepted Solutions
Solution
‎12-11-2014 11:01 AM
SAS Super FREQ
Posts: 8,814

Re: ODS PDF/Excelxp simultaneous destinations

If you are using ODS LAYOUT within your code, then the error message is telling you the problem. Not all destinatins support ODS LAYOUT. You might need to have 2 separate steps for each destination.

cynthia

View solution in original post


All Replies
Solution
‎12-11-2014 11:01 AM
SAS Super FREQ
Posts: 8,814

Re: ODS PDF/Excelxp simultaneous destinations

If you are using ODS LAYOUT within your code, then the error message is telling you the problem. Not all destinatins support ODS LAYOUT. You might need to have 2 separate steps for each destination.

cynthia

Contributor
Posts: 51

Re: ODS PDF/Excelxp simultaneous destinations

Thank you

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 439 views
  • 0 likes
  • 2 in conversation