Hi,
I could not find a solution for this problem on the board so I thought I would ask instead.
As the long subject line says,
If a variable A meets certain conditions then I want to delete all observations with the same variable B as the other observation.
If A >10 and B is 5, then I want to remove all variables where B=5.
I want this
Obs A B
1 5 10
2 11 10
3 1 11
4 9 11
5 12 12
6 3 13
To become this
1 1 11
2 9 11
3 3 13
Thanks in advance!
Here you go:
data have;
input a b;
datalines;
5 10
11 10
1 11
9 11
12 12
3 13
;
data want;
if _n_=1 then
do;
dcl hash h1(dataset:'have(where=(a>10))');
h1.defineKey('b');
h1.defineDone();
end;
set have;
if h1.check()=0 then delete;
run;
proc print data=want;
run;
I don't see one obs where B=5?
Here you go:
data have;
input a b;
datalines;
5 10
11 10
1 11
9 11
12 12
3 13
;
data want;
if _n_=1 then
do;
dcl hash h1(dataset:'have(where=(a>10))');
h1.defineKey('b');
h1.defineDone();
end;
set have;
if h1.check()=0 then delete;
run;
proc print data=want;
run;
Ok. I would go with the solution by @Patrick then.
Alternatively you could do
data have;
input a b;
datalines;
5 10
11 10
1 11
9 11
12 12
3 13
;
data want;
array _ {1000000} _temporary_;
do until (lr1);
set have(where=(a>10)) end=lr1;
_[b]=1;
end;
do until (lr2);
set have end=lr2;
if _[b] ne 1 then output;
end;
stop;
run;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.