ODS PDF Filename from Variable

laura6728 — Fri, 20 Sep 2019 15:08:04 GMT

I have an ODS pdf that currently produces one file, and within the file are two pages per faculty member at our institution. I made a modification to the code so that there is one file per faculty member with the two needed pages. Is there a way that I can pass the faculty members name from the dataset to the filename? Currently, it is naming the successive files with (1), (2), (3), etc. however, I would like the file to have REPORTNAME_JDOE.PDF, REPORTNAME_DDUCK.PDF, etc. Any direction would be appreciated!

Re: ODS PDF Filename from Variable

Reeza — Fri, 20 Sep 2019 15:20:37 GMT

Sadly no.

I wish you could control the names, but you could with a macro/call execute.

Another option is to rename the files after the fact but I dislike doing that, because it assumes order though I suppose you could check that. There is a RENAME() function that will rename files via a data step.

This illustrates how to do it via macro:

https://github.com/statgeek/SAS-Tutorials/blob/master/Turning%20a%20program%20into%20a%20macro.md

@laura6728 wrote:

I have an ODS pdf that currently produces one file, and within the file are two pages per faculty member at our institution. I made a modification to the code so that there is one file per faculty member with the two needed pages. Is there a way that I can pass the faculty members name from the dataset to the filename? Currently, it is naming the successive files with (1), (2), (3), etc. however, I would like the file to have REPORTNAME_JDOE.PDF, REPORTNAME_DDUCK.PDF, etc. Any direction would be appreciated!

topic Re: ODS PDF Filename from Variable in ODS and Base Reporting

ODS PDF Filename from Variable

Re: ODS PDF Filename from Variable