topic Re: Beginner's report. in ODS and Base Reporting

Beginner's report.

deleted_user — Tue, 17 Feb 2009 10:01:05 GMT

I am a SAS beginner.
I have a SAS data table with columns:

Identity (X?....?)
Gender (1,2)
Class (1,2)
Mark (1,2,3,4,5)

Variable Mark is numeric, the remaining of character type.

I want to create a summary report with PROC REPORT.

On the first line I would like to have the table total numbers for men(1), women(2) and total.
On the third line Class 1 numbers.
On lines 4-8 the number of individuals in Class 1 with different marks.

On lines 10-15 Class 2 in the same way as Class 1.

If I could get some help I would be most grateful.
Best regards
Anne

Re: Beginner's report.

Cynthia_sas — Tue, 17 Feb 2009 20:23:49 GMT

Hi:
I don't understand what you mean by "class 1 numbers on third line" the rest of the description is clear.

cynthia

Re: Beginner's report.

prholland — Wed, 18 Feb 2009 00:02:33 GMT

Anne,

Is this what you are looking for?

PROC REPORT DATA=table NOWD;
COLUMNS class identity mark gender,(N) overall;
DEFINE class / GROUP;
DEFINE identity / GROUP;
DEFINE mark / GROUP;
DEFINE gender / ACROSS;
DEFINE overall / COMPUTED;
COMPUTE overall;
overall = SUM(_c5_, _c6_);
ENDCOMP;
BREAK BEFORE class / SUMMARIZE;
RBREAK BEFORE / SUMMARIZE;
RUN;

...............Phil

Re: Beginner's report.

deleted_user — Wed, 18 Feb 2009 10:09:25 GMT

Cynthia,

I meant the sum of individuals (the number of individuals) in Class 1.

Bad english by me. Where I come from we talk rotvälska all the time.

Anne

Re: Beginner's report.

deleted_user — Wed, 18 Feb 2009 10:11:07 GMT

Thank you very much, Phil.

Your example seems useful. I am working on it.

Anne