topic Re: Using Proc means to get values in desired format in SAS Programming

Using Proc means to get values in desired format

DeepakSwain — Fri, 19 Oct 2018 18:22:40 GMT

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,

Re: Using Proc means to get values in desired format

pink_poodle — Fri, 19 Oct 2018 18:29:41 GMT

Here is one way of doing that :

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

Re: Using Proc means to get values in desired format

ballardw — Fri, 19 Oct 2018 18:36:16 GMT

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.

Re: Using Proc means to get values in desired format

DeepakSwain — Fri, 19 Oct 2018 18:43:03 GMT

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

Re: Using Proc means to get values in desired format

PaigeMiller — Fri, 19 Oct 2018 18:48:15 GMT

You can put the format statement in PROC MEANS.

Re: Using Proc means to get values in desired format

DeepakSwain — Fri, 19 Oct 2018 19:11:35 GMT

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

Re: Using Proc means to get values in desired format

Ksharp — Sat, 20 Oct 2018 10:33:27 GMT


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;