topic Re: Proc Report (Not getting Min and Mean of same variable) in SAS Programming

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

Divya_Joseph — Wed, 02 Aug 2017 02:21:34 GMT

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

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

art297 — Wed, 02 Aug 2017 04:16:32 GMT

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#n0ldy84v9j7463n1jjkloe7av38c.htm

Art, CEO, AnalystFinder.com

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

subobscure — Wed, 02 Aug 2017 04:48:25 GMT

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#n0ldy84v9j7463n1jjkloe7av38c.htm

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

Divya_Joseph — Wed, 02 Aug 2017 08:12:21 GMT

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