The SAS Output Delivery System and reporting techniques

Mixing proc and data step RWI output in ODS LAYOUT destinations

Accepted Solution Solved
Reply
Regular Contributor
Posts: 163
Accepted Solution

Mixing proc and data step RWI output in ODS LAYOUT destinations

Hi,

 

Is it possible to mix data step RWI and proc outputs going to the same ODS destination?  I'm using the absolute method in a data step RWI but want to populate some of the regions with proc-produced graphics.  The structure of the RWI in the data step suggests 'no' since the entire container must be defined.

 

Thanks!

 

--Ben


Accepted Solutions
Solution
‎06-01-2016 09:49 AM
SAS Super FREQ
Posts: 8,718

Re: Mixing proc and data step RWI output in ODS LAYOUT destinations

Ben:
I am using ODS LAYOUT and ODS REGION, but my RWI call is a single datastep within the larger ODS statements. So I did not have to retrieve any images, they were inserted as they were created. This may not work for you. The References at the end of my paper have a lot of other papers. I think you will want to look at the O'Connor papers and one of them, had an absolute layout example.

cynthia

View solution in original post


All Replies
Grand Advisor
Posts: 9,571

Re: Mixing proc and data step RWI output in ODS LAYOUT destinations

The following code could give you some hint.

 

data _null_;

 file print;

 set sashelp.class;

 put _all_;

run;

proc print data=sashelp.class;run;

SAS Super FREQ
Posts: 8,718

Re: Mixing proc and data step RWI output in ODS LAYOUT destinations

It depends on what you mean by mixing the PROC steps and the RWI output. If you use a method similar to my last example 7 in this paper: http://support.sas.com/resources/papers/proceedings16/SAS5762-2016.pdf on pages 23/24. Where I have PROC REPORT at the top of the output, I was successful using the RWI for a different report at the top of the graphs. Note that the example does use ODS LAYOUT and ODS REGION, but at the ODS level, not at the RWI level.

Hope this helps.

cynthia
Regular Contributor
Posts: 163

Re: Mixing proc and data step RWI output in ODS LAYOUT destinations

Hi Cynthia, That looks like exactly what I was trying to do. We have a 4 page report heavy with graphs that has to be generated for about 20,000 clients. Picky layout, so an Absolute layout seemed appropriate. There will be text inserted in to the pages as well as graphs from SAS procs and external .png file (headers, etc.). Thinking this through a little more carefully, I think pre-generating the proc outputs (mostly graphs but a few tables) would be the most efficient approach. Put them in a document store and pull them out with a RWI data step? How does one retrieve a given image/table from a document store in the RWI? Target output will be a pdf file, and that's another issue, since the pdf filename can't be created dynamically that I know of. Wish there was a filevar option for ODS PDF output. Open to suggestions on approaches on this task. Will read the paper in the morning after coffee. Thanks! --Ben
Solution
‎06-01-2016 09:49 AM
SAS Super FREQ
Posts: 8,718

Re: Mixing proc and data step RWI output in ODS LAYOUT destinations

Ben:
I am using ODS LAYOUT and ODS REGION, but my RWI call is a single datastep within the larger ODS statements. So I did not have to retrieve any images, they were inserted as they were created. This may not work for you. The References at the end of my paper have a lot of other papers. I think you will want to look at the O'Connor papers and one of them, had an absolute layout example.

cynthia
Regular Contributor
Posts: 163

Re: Mixing proc and data step RWI output in ODS LAYOUT destinations

Cynthia,

Thanks again for the help. Your paper has a huge amount of cool stuff in it. I'm sure I can find what I need in there.
Much appreciated!

Ben
☑ This topic is SOLVED.

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

Discussion stats
  • 5 replies
  • 351 views
  • 0 likes
  • 3 in conversation