Proc means simple question

[sonyk]

Hi

I have to tabulate the N,mean,stddev of acess data set. My code for that is below

proc means data=Sasuser.ClinicalExam nonobs n mean stddev maxdec=2;
label pulse = 'pulse'
Bpsytolic = 'Systolic BP'
BpDiastolic = 'Diastolic BP';
Var pulse bpsys bpdias;
run;

My result is having 5 columns :

variable label N mean stddev

but i shud have only the below in result :

Label N Mean Stddev

how to ignore Variable column fro the result ?

[ballardw]

Quickest would be to use Tabulate:

Proc tabulate data=Sasuser.ClinicalExam ;
label pulse = 'pulse'
Bpsytolic = 'Systolic BP'
BpDiastolic = 'Diastolic BP';
Var pulse bpsys bpdias;

table pulse bpsys bpdias, n mean*f=f10.2 stddev*f=f10.2;
run;

Also,since you don't have and CLASS variables you don't need the NONOBS in your MEANS example.

[sonyk]

Thanks.But i have to get column name 'Label' above pulse,bpsystolic and bpdiastolic

[ballardw]

table pulse bpsys bpdias, n mean*f=f10.2 stddev*f=f10.2
/box='Label';

will put Label at the top of the column of variables.