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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.