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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.