Proc Report define statement

[dyrma]

Hi, everyone

I would like to use proc report to create this output:

I'm trying this way:

proc report data=sashelp.class;
    column sex name age;
    define sex / group;
    define age / max  'Max. Age';
    define name / ????????;
run;

How to define 'name' to receive the output above?

Thanks very much for your suggestions.

[Reeza]

You don't have to include anything...

define name;

[RW9]

Thats not going to work.  You are summarising data by sex - name has no relevance in this summarisation.  Why should it show Jane and not some other value?  Makes no sense to have name as a column there.

[dyrma]

I just want to show who is the oldest.

[Reeza]

Use PROC SUMMARY with the ID to associate the name with the highest value. You can use PROC REPORT to display the output. 

PROC REPORT can summarize data but it's easier outside IMO. 

[dyrma]

Does this mean that proc report can not handle it?

[RW9 · Accepted solution]

It may be possible, with some coding effort, however data processing really isn't the purpose of proc report. Use one of the data summarisation procedures (summary for instance) or you could simply sort the data and take first by group observation.   

[dyrma]

thanks a lot Reeza and RW9