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
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
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
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:
Thank you for sending me the answer. I tried and it worked for me.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.