Using Proc means to get values in desired format

[DeepakSwain]

Hi there,

I am trying to get mean, median and P95 using Proc means in a desired format such as mean_pulse as integer and P50 and P95 

with one decimal. Can some body help me to modify my code to get the desired output.

data test;
input id  pulse;
cards;
1 2
4 5
7 8
1 3
4 5
7 8
1 2
4 5
7 9
1 2
4 7
7 8
1 5
4 7
7 8
;
run;
 

proc sort data =test; by id; run;

proc means data =test noprint;
var pulse;
by id ;
output out=want (drop= _type_ _freq_) mean=mean_pulse p50=median_pulse p95=pctile_95;
run;

At present, I am getting median and P95 as whole number but I want with a decimal. 

Regards,

[pink_poodle]

Here is one way of doing that :

data want2;
    set want;
    format median_pulse pctile_95 10.1;
run;

[DeepakSwain]

Hi pink_poodle,
Is there a way to put desired format with P50 and P95 in proc means statement.

[PaigeMiller]

You can put the format statement in PROC MEANS.

[DeepakSwain]

Hi PaigeMiller,

Great. I am trying to use format statement with proc means. Can you kindly suggest the necessary modification in the above code.
Thanks

[Ksharp · Accepted solution]

proc means data =test noprint;
var pulse;
by id ;
output out=want (drop= _type_ _freq_) mean=mean_pulse p50=median_pulse p95=pctile_95;
format _numeric_ 10.1;
run;

[ballardw]

For your mean do want the value to actually be an integer or just appear as such? Apply a format such as F5. and the appearance will be rounded to an integer value. Or use a data step and actually round or truncate the value with ROUNT, FLOOR or CEIL functions.