topic Re: How to find median of Age variable in SAS Programming

How to find median of Age variable

CathyVI — Sun, 23 Apr 2023 15:51:42 GMT

Hi,

This might be very simple but I will like to find the median (IQR) of an age variable. The age variable is in character format and the code is three digits. Here is an example:

data have;
input Age $;
datalines;
042
043
055
035
065
066
070
098
;
run;

I thought about removing the 0 before converting data to numeric but I don't know how. Is this a meaning idea ?

Re: How to find median of Age variable

sbxkoenk — Sun, 23 Apr 2023 16:08:39 GMT

data have;
input Age $;
datalines;
042
043
055
035
065
066
070
098
;
run;

data have1;
 set have;
 AgeNum=input(Age,3.);
run;

proc means data=have1 median qrange fw=8;
 var AgeNum;
 output out=want median= qrange= / autoname;
run;
/* end of program */

Re: How to find median of Age variable

Kurt_Bremser — Sun, 23 Apr 2023 18:30:38 GMT

Why do you read a number as character?