topic summary statistics in SAS Programming

summary statistics

Selvan05 — Tue, 30 Jul 2019 13:51:11 GMT

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

Re: summary statistics

PaigeMiller — Tue, 30 Jul 2019 14:05:28 GMT

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

Re: summary statistics

Cynthia_sas — Tue, 30 Jul 2019 16:12:33 GMT

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

Re: summary statistics

Selvan05 — Mon, 05 Aug 2019 13:42:00 GMT

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