topic Re: Export each page of my report to custom named html file (Combination of static text and variable in SAS Programming

Export each page of my report to custom named html file (Combination of static text and variable)

VCucu — Fri, 24 Jul 2020 20:22:47 GMT

Hello,
 
i have the following code for writing a report to HTML:
 
"
ods html file='C:\analysis1.html'
newfile=page;
proc report data=sales nowd list headline headskip spacing=2 split='~';
by branchid;
column (branchid representative sales);
define branchid / group noprint;
define representative / display 'Representative Name';
define Sales / display f=comma20. 'Yearly Sales';
run;
ods html close;
"
This creates for each change of branch ID in the report an incremental file e.g.:
analysis1.html
analysis2.html
analysis3.html
...
 
Is there any way to change the name of the output html file for each page dynamically? i would like to have a combination of 'analysis1' || trim(branchid) ||'.html' variable, resulting in
analysis1HK.html           (Hong Kong Branch)
analysis1LO.html           (London Branch)
....
and so on for all branchid defined in the report.
 
Is this possible somehow ?
 
Thank you very much,

Re: Export each page of my report to custom named html file (Combination of static text and variable

Reeza — Fri, 24 Jul 2020 21:27:01 GMT

Unfortunately not at this point. One option is to add a rename step to the file, but you need to do it after you have the ODS CLOSE statement so the file is created and finalized.
https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p14axci3mo3egan1okbcydvbt433.htm&docsetVersion=9.4&locale=en

Another option, one I usually use, is to use a macro instead and explicitly control the output name.
https://github.com/statgeek/SAS-Tutorials/blob/master/Turning%20a%20program%20into%20a%20macro.md

Re: Export each page of my report to custom named html file (Combination of static text and variable

VCucu — Sat, 25 Jul 2020 15:00:08 GMT

super. thank you very much for the feedback. 🙂 i will try the macro variant.