topic Re: how to trim numerical variables in sas? in SAS Procedures

how to trim numerical variables in sas?

batool89 — Sun, 03 Sep 2017 09:34:46 GMT

Hello,

I have a sample including the variables of Return, Earnings and Size from 1980 to 2015. I want to remove (delete) the higher and lower 1% of each variable's observations each year using SAS 9.4. however, I am not sure about the codes I should use.

can you please help me?

thanks in advance

Re: how to trim numerical variables in sas?

Miracle — Sun, 03 Sep 2017 10:13:09 GMT

this will help Sample 58955: How to select or delete the top 1% and bottom 1% of observations from a data set

Re: how to trim numerical variables in sas?

batool89 — Sun, 03 Sep 2017 10:50:35 GMT

thank you so much. can you please advise me how to extend the code to do this for each year?

Re: how to trim numerical variables in sas?

Ksharp — Sun, 03 Sep 2017 11:11:58 GMT

The following delete the top and bottom 20% data for each year.

If you need 1% change GROUPS=100 and NOT IN (0 99) .

data air;
 set sashelp.air;
 year=year(date);
 drop date;
run;
proc rank data=air out=temp groups=5;
by year;
var air;
ranks r_air;
run;
data want;
 set temp;
 if r_air not in (0 4);
run;

Re: how to trim numerical variables in sas?

MINX — Fri, 08 Sep 2017 18:47:55 GMT

@Ksharp This is a good approach. But Proc Rank only works when obersvation numbers are larger than GROUPS size. I did a draft based on the reference by @Miracle

data air;
 set sashelp.retail;
 rename sales=air;
 drop date;
run;

proc means data=air noprint;
by year;
var air;
output out=stat
		p1=p1
		p99=p99;
run;

data r_air;
merge air(in=x) stat(keep=year p1 p99);
by year;
if x;
run;

data want;
 set r_air;
 if p1<=air<=p99;
run;

Re: how to trim numerical variables in sas?

batool89 — Wed, 27 Sep 2017 08:59:48 GMT

thank you all. I appreciate your help.

I tried Proc Rank and it worked.