topic Re: ODS PDF/Excelxp simultaneous destinations in ODS and Base Reporting

ODS PDF/Excelxp simultaneous destinations

RB1Kenobi — Thu, 11 Dec 2014 15:44:36 GMT

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

Re: ODS PDF/Excelxp simultaneous destinations

Cynthia_sas — Thu, 11 Dec 2014 16:01:24 GMT

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

Re: ODS PDF/Excelxp simultaneous destinations

RB1Kenobi — Fri, 12 Dec 2014 08:12:17 GMT

Thank you