topic Re: Multiple row condition in SAS Programming

Multiple row condition

Chris_LK_87 — Tue, 25 May 2021 10:44:17 GMT

Hello,

I have a dataset with individuals that contains their balance. The individuals can appear multiple times. I would like to select the individuals that both have positive and negative balance.

data have;
length id $10 balance $48;
input id$ balance$;
datalines;
1 25
1 10
2 20
2 -30
3 40
3 80
4 -7
4 2
;
run;

Data want;

set have;

id$ balance$

2 20

2 -30

4 -7

4 2

Re: Multiple row condition

PaigeMiller — Tue, 25 May 2021 11:10:16 GMT

Is there some reason you have BALANCE as a character variable?

data have;
input id $ balance;
datalines;
1 25
1 10
2 20
2 -30
3 40
3 80
4 -7
4 2
;
run;

proc sql;
    create table want as select *
    from have 
    group by id
    having min(balance)<0 and max(balance)>0;
run;

Re: Multiple row condition

Chris_LK_87 — Tue, 25 May 2021 13:37:46 GMT

Thank you!

Your solution worked.

Of course BALANCE should be numerical, my mistake.