Dear Team,
Is there any method in SAS to create report in the below given format? There is a requirement to print column header in every row.
Student ID | student Name | Standard | Division | Term | ||||
1st instalment |
| |||||||
Tuition fee | Annual fee | Computer fee | Development fee | Total | ||||
A115 | Shravan | X | A | 2000 | 500 | 100 | 400 | 3000 |
|
|
|
|
|
|
|
|
|
Student ID | student Name | Standard | Division | Term | ||||
2nd instalment |
| |||||||
Tuition fee | Annual fee | Computer fee | Developement fee | Total | ||||
A115 | Shravan | X | A | 2200 | 600 | 200 | 500 | 3500 |
What kind of output format do you need to create: HTML, PDF, CSV,...?
If it is PDF, there is a way for Proc REPORT to do this using a group var that changes for every row.
See sample below.
data myclass;
gName + 1;
set sashelp.class;
run;
filename xpdf temp;
ods pdf file=xpdf;
ods pdf startpage=no;
proc report data=myClass nocenter;
column gName name sex age;
define gName / group noprint;
define name / display;
define sex / display;
define age / display;
break after gname / page;
compute before gname / style={just=left};
length printLine $ 80;
printLine = catx(":", "Line for", gName);
line printLine $char80.;
endcomp;
run;
ods pdf close;
So depending on what you need there might be a different approach.
Bruno
Thanks , This is working.
Please mark @BrunoMueller's answer as correct.
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.