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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.