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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.