DATA Step, Macro, Functions and more

looking for 15’ percentile

Reply
Occasional Learner
Posts: 1

looking for 15’ percentile

dear SAS community,

i hope i can describe what my question is.

 

i’ve been trying to analyze a sample through percentiles.

 

i’ve used the tool “statistiche di riepilogo” which translated could be something like “summary statistics”.

 

in option, i can tick 1. 10, 25, 50, 75, 95, 99 percentile.

but i want 15!

 

anyone can help?

 

i’ve already tried to change the codes but, when i write p15 it  reports me this p15 as an error.

Looking forward to hearing from you!

 

federica

SAS Employee
Posts: 30

Re: looking for 15’ percentile

Posted in reply to federicamazetta

When using the "statistiche di riepilogo" you will be automatically generating PROC MEANS code. Unfortunately, PROC MEANS does not support custom percentiles as you're asking for. You can, however, use some other procedures such as PROC UNIVARIATE or PROC STDIZE. I recommend PROC STDIZE but you can see examples of both used in this blog post.

 

Here's a [slightly modified] snippet of code running the STDIZE procedure as you are looking for.

proc stdize data=sashelp.cars PctlMtd=ORD_STAT outstat=StdLongPctls
           pctlpts=15;
var mpg_city mpg_highway;
run;
 
proc print data=StdLongPctls noobs;
where _type_ =: 'P';
run;
Ask a Question
Discussion stats
  • 1 reply
  • 91 views
  • 3 likes
  • 2 in conversation