topic Re: Proc Report define statement in ODS and Base Reporting

Proc Report define statement

dyrma — Tue, 17 Oct 2017 16:02:57 GMT

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.

Re: Proc Report define statement

Reeza — Tue, 17 Oct 2017 16:10:28 GMT

You don't have to include anything...

define name;

Re: Proc Report define statement

RW9 — Tue, 17 Oct 2017 16:11:56 GMT

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.

Re: Proc Report define statement

dyrma — Tue, 17 Oct 2017 16:21:23 GMT

I just want to show who is the oldest.

Re: Proc Report define statement

Reeza — Tue, 17 Oct 2017 16:23:18 GMT

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.

Re: Proc Report define statement

dyrma — Tue, 17 Oct 2017 16:29:20 GMT

Does this mean that proc report can not handle it?

Re: Proc Report define statement

RW9 — Tue, 17 Oct 2017 16:58:05 GMT

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.

Re: Proc Report define statement

dyrma — Wed, 18 Oct 2017 08:21:17 GMT

thanks a lot Reeza and RW9