topic Re: Attach percentile data to my dataset in SAS Programming

Attach percentile data to my dataset

benvar — Wed, 12 Jun 2019 17:22:48 GMT

I have a dataset for which I want to know the p25, p50, and p75 (and maybe other) percentiles for var1 (first variable) when the data is grouped by var2 (second variable). I was able to do this using PROC UNIVARIATE but I then lose my original data once I output from PROC UNIVARIATE. Is there a way to calculate the percentiles and merge it back with my original dataset?

Re: Attach percentile data to my dataset

PaigeMiller — Wed, 12 Jun 2019 17:41:31 GMT

Example:

proc summary data=have nway;
    class var2;
    var var1;
    output out=pctiles p25=p25 p50=p50 p75=75;
run;
proc sort data=have;
    by var2;
run;
data want;
    merge have pctiles;
    by var2;
run;

Re: Attach percentile data to my dataset

Astounding — Wed, 12 Jun 2019 17:42:14 GMT

You can't attach it as part of PROC UNIVARIATE. Run that first, then put the results back onto your original data set ... either MERGE by VAR2, or use SQL, matching on VAR2.

Re: Attach percentile data to my dataset

Reeza — Wed, 12 Jun 2019 19:11:18 GMT

Here's an illustration of two different methods:

https://github.com/statgeek/SAS-Tutorials/blob/master/add_average_value_to_dataset.sas

Another option, if you're trying to bin groups with percentiles is to use the RANK procedure instead.

@benvar wrote:

I have a dataset for which I want to know the p25, p50, and p75 (and maybe other) percentiles for var1 (first variable) when the data is grouped by var2 (second variable). I was able to do this using PROC UNIVARIATE but I then lose my original data once I output from PROC UNIVARIATE. Is there a way to calculate the percentiles and merge it back with my original dataset?