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;

If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

1155

---

what is star schema? : Sas-di

1121

---

how do you test for missing values? : Sas programming

1042

---

What do the SAS log messages "numeric values have been converted to character" mean?

1369

---

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1068

---

What do the mod and int function do? : Sas programming

1207

---

what are several options for creating reports in web report studio? : Sas-bi

1141

---

Do you need to know if there are any missing values?

1034

---

Describe a time when you were really stuck on a problem and how you solved it?

2628

---

How to limit decimal places for variable using proc means?

1091

---

For clinical entire study how many tables will create approx?

1960

---

what is the difference between floor and ceil functions in sas? : Sas-administrator

1246

---

What was the last computer book you purchased? Why?

2368

---

How do you test for missing values?

1623

---

what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

1220

---