Proc Report (Not getting Min and Mean of same variable)

[Divya_Joseph]

Hi,

Proc Report Data=Cars;
Column MSRP Length;
Define MSRP/Max;
Define Length/Min;
Define Length/Mean;
Run;

I got only the Mean of Length variable . I didn't get the Minimum of Length variable. Anyone help me what is the problem of this code?

Thank you

[art297 · Accepted solution]

You need to create aliases. A nice example can be found at: http://support.sas.com/documentation/cdl/en/proc/70377/HTML/default/viewer.htm#n0ldy84v9j7463n1jjklo...

Art, CEO, AnalystFinder.com

[subobscure]

Since, you want to perform analysis on same column and represent it in 2 separate columns of your report as min and mean, you will have to create aliases.

Your code should be something like ...

Proc Report Data=Cars;
Column MSRP Length=Length_min Length=Length_mean;
Define MSRP/Max;
Define Length_min/Min;
Define Length_mean/Mean;
Run;

I have assumed that MSRP and Length variables are numeric in your dataset.

More information can be found on the SAS documentation:

http://support.sas.com/documentation/cdl/en/proc/70377/HTML/default/viewer.htm#n0ldy84v9j7463n1jjklo...

[Divya_Joseph]

Thank you for sending me the answer. I tried  and it worked for me.