I used the following code to generate mean and median, and the mean function gives me one number only, but the median function gives a list of numbers. Am I supposed to get one number from the median funciton?

Thanks!

proc sql;
select distinct feature, median(value) as median, mean(value) as mean
from dataname
;
quit;

Include a group by clause,

see below

proc sql;
select distinct feature,
median(value) as median,
mean(value) as mean
from dataname

group by feature
;

Group by will not work. Median is a row wise function. it is not a aggragate function

Go through this
http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0608c&L=sas-l&P=55847