BookmarkSubscribeRSS Feed
aneeshv
Fluorite | Level 6

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

3 REPLIES 3
BrunoMueller
SAS Super FREQ

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
Fluorite | Level 6

Thanks , This is working.

 

RW9
Diamond | Level 26 RW9
Diamond | Level 26

Please mark @BrunoMueller's answer as correct.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

Creating Custom Steps in SAS Studio

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1230 views
  • 0 likes
  • 3 in conversation