Can you calculate the mean, median and mode of the following data set
using data step logic? Don't use any function or procedure.
data a;
input age @@;
datalines;
22 32 32 32 43 23 24 56 45 54 28 29 27 26 25 28 30 20 18 37 36 47 46
56 19 20
;
run;
I have calculated the mean which i have posted in the answer section.
Answer Posted / rg
data temp;
input age @@;
cards;
8 7 7 2 67 9 7 7 1 2 45 34 22 45 23 8 34 23
run;
proc sort data=temp; by age ;run;
data a(keep = median mode_age mean);
last_age=age;
retain max_cnt mode_age median;
set temp end=lastobs nobs=n;
by age;
age_temp + age;
/*Median */
if mod(n,2) = 1 and _n_ = (n+1)/2 then do ;median=age; end;
if mod(n,2) = 0 and _n_ = (n+2)/2 then do ;median=(age + last_age)/2; end;
/*Mean*/
if lastobs then do mean=age_temp/n ; end;
/*Mode */
if first.age then cnt =1; else cnt+1;
if last.age then lst_cnt=cnt;
if lst_cnt > max_cnt then do; max_cnt = lst_cnt; mode_age = age;end;
if lastobs then output;
run;
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
how will you location sas platform applications available from web browser? : Sas-bi
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
What is the difference between %local and %global? : sas-macro
How do you specify the number of iterations and specific condition within a single do loop?
Tell e how how dealt with..
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
why a stop statement is needed for the point= option on a set statement?
Explain by-group processing?
how do you pull data from equifax?tell me the process?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
For what purposes have you used sas macros? : sas-macro
describe the interaction table in sas di? : Sas-di
Give an example where SAS fails to convert character value to numeric value automatically?
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
explain the use of % includes a statement in sas? : Sas-administrator