🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Fluorite | Level 6

## Creating a subgroup and finding the deciles of the remaining observations

```Dear All:My data is as followsVarA          IDA
4                1
6                2
2                3
1                4
10              5
22              6
2                7
1                8
85              9
I want to create a subgroup when VARA = 1 and VarA = 2, name the subgroup
as Rank = 0 and then find find the deciles for the remaining values.```

`ThanksRamdy`

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Creating a subgroup and finding the deciles of the remaining observations

proc rank data=have groups=10;
where vara not in (1,2);
var varA;
ranks rank_varA;
run;
4 REPLIES 4
Super User

## Re: Creating a subgroup and finding the deciles of the remaining observations

VARA = 1 and VarA = 2, you mean OR I assume?

proc univariate data=have ;
where vara in (1,2);
var ida;
output out=deciles pctlpre = P_ pctlpts=0 to 100 by 10;
run;

https://stats.idre.ucla.edu/sas/faq/how-do-i-obtain-percentiles-not-automatically-calculated/
run;
Diamond | Level 26

## Re: Creating a subgroup and finding the deciles of the remaining observations

I want to create a subgroup when VARA = 1 and VarA = 2, name the subgroup as Rank = 0 and then find find the deciles for the remaining values.

I'm really struggling to decipher this into something I could program. When you talk about "the remaining values", are these the values that are not in RANK=0? Or are they the values of VARA=1 and VARA=2? Why the name RANK=0, this seems to imply something, but I can't figure it out. Is there also a RANK=1?

Can you show us the desired output from this small example?

--
Paige Miller
Fluorite | Level 6

## Re: Creating a subgroup and finding the deciles of the remaining observations

Paige -- Here is the intuition.  I have a column with a series of values.  I want to group them into deciles, but not include values of 1 or 2 into the decile grouping, keeping them as a separate group.

so if the values of VarA are

VARA              Rank_A

1                        -1

3                        1

6                        2

8                        3

9                        4

14                      5

2                        -1

66                      6

VARA = 1 OR VARA =2 always get a rank of say  ( -1 or 0 -- it does not matter) and the ranks are determined on the remaining values.  I hope that I am clearer -- I apologize for any confusion.

Randy

Super User

## Re: Creating a subgroup and finding the deciles of the remaining observations

proc rank data=have groups=10;
where vara not in (1,2);
var varA;
ranks rank_varA;
run;
Discussion stats
• 4 replies
• 591 views
• 0 likes
• 3 in conversation