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
Hi:
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
cynthia
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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.