06-26-2017 11:39 AM
In my output some roll numbers are there with each roll number 10 to 30 transactions are there, i want to export each roll number as a pdf file, can anybody help to write macro or sas code to export each roll number transactions into one pdf
06-26-2017 11:55 AM - edited 06-26-2017 11:58 AM
If you use BY group processing, SAS and ODS will automatically make a PDF file for every BY group. Consider this code, which makes 1 PDF for every age when age is used as a BY variable with a BY statement.
proc sort data=sashelp.class out=class; by age; where age in (12, 13, 14); run; ods pdf file='c:\temp\bygrp_age1.pdf' newfile=bygroup; proc print data=class; by age; var age name sex height weight; run; ods pdf close;
For example, the above code makes 3 PDF files, one for each AGE -- and changes the name for each file it makes:
Age 12 c:\temp\bygrp_age1.pdf
Age 13 c:\temp\bygrp_age2.pdf
Age 14 c:\temp\bygrp_age3.pdf
You only need a SAS macro approach if you want to control the names of the output files being created. Otherwise NEWFILE=BYGROUP does it for you automatically.
If you need a macro program, you will find a relevant example in this paper: https://support.sas.com/resources/papers/proceedings13/120-2013.pdf
06-26-2017 02:56 PM
Thank you for your solutions it is working, but please help on one more.. i want to save each file with that age and person name automatically can you help on this
06-26-2017 03:19 PM