Desktop productivity for business analysts and programmers

PROC Report

Reply
Occasional Contributor
Posts: 7

PROC Report

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

SAS Super FREQ
Posts: 706

Re: PROC Report

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

Occasional Contributor
Posts: 7

Re: PROC Report

Thanks , This is working.

 

Super User
Super User
Posts: 7,720

Re: PROC Report

Please mark @Bruno_SAS's answer as correct.

Ask a Question
Discussion stats
  • 3 replies
  • 93 views
  • 0 likes
  • 3 in conversation