PROC Report

[aneeshv]

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

[BrunoMueller]

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

[aneeshv]

Thanks , This is working.

[RW9]

Please mark @BrunoMueller's answer as correct.