topic Re: Proc means simple question in SAS Procedures

Proc means simple question

sonyk — Fri, 17 Jun 2011 16:35:25 GMT

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 ?

Re: Proc means simple question

ballardw — Fri, 17 Jun 2011 17:16:29 GMT

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.

Re: Proc means simple question

sonyk — Mon, 20 Jun 2011 15:53:16 GMT

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

Re: Proc means simple question

ballardw — Mon, 20 Jun 2011 19:23:35 GMT

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.