summary statistics

[Selvan05]

Hi,

Can anyone help me to understand how a simple tabular report/summary can be produced with SAS? I am looking for something like 

for each department in an university, the number of students in each year with a total.

Department	Year 1	Year 2	year 3	Total
Economics	60	55	61	176
Statistics	50	48	49	147

Thanks in advance!

Selvan

[PaigeMiller]

I can't give you exact code until we can see the actual data, but any of these PROCs ought to work

REPORT
TABULATE
SUMMARY

FREQ

[Cynthia_sas · Accepted solution]

Consider some fake data, created from SASHELP.SHOES so that the data has 2 different values for YEAR:

TABULATE & REPORT:

FREQ & MEANS:

Hope this helps to point you in the right direction.

Cynthia

[Selvan05]

Hi Cynthia and Paige Miller,

Firstly apologies for the late response. I was away from work and could check our community page.

Thank you very much for your responses. this is very helpful for my implementation.

Br,
Selvan