topic Re: If then statement involving two different dataset and two different variables in SAS Programming

If then statement involving two different dataset and two different variables

kmardinian — Mon, 24 Sep 2018 15:42:16 GMT

Hi, I am working with two datasets (x and y) and I would like to exclude all observations that are in dataset Y from dataset X.

For example, my datasets look like this

Dataset X Dataset Y

ID Value IDNUM

1 25 2

2 30

3 50

I would like to find a way where I can tell SAS that I want observations for ID 2 to be deleted from dataset X, but the ID variables are also named differently. Any advice on where to start and how to go about this would be very helpful! Thank you!

Re: If then statement involving two different dataset and two different variables

Reeza — Mon, 24 Sep 2018 15:47:10 GMT

This is pretty straightforward when using PROC SQL.

proc sql;
create table selected as
select * 
from X
where ID not in (select IDNUM from Y);
quit;

@kmardinian wrote:

Hi, I am working with two datasets (x and y) and I would like to exclude all observations that are in dataset Y from dataset X.

For example, my datasets look like this

Dataset X                        Dataset Y

ID     Value                        IDNUM

1         25                               2

2         30

3         50

I would like to find a way where I can tell SAS that I want observations for ID 2 to be deleted from dataset X, but the ID variables are also named differently. Any advice on where to start and how to go about this would be very helpful! Thank you!

Re: If then statement involving two different dataset and two different variables

Kurt_Bremser — Mon, 24 Sep 2018 15:54:17 GMT

Assuming both datasets are sorted correctly:

data want;
merge
  x (in=x)
  y (in=y rename=(idnum=id))
;
by id;
if x and not y;
run;

Re: If then statement involving two different dataset and two different variables

kmardinian — Mon, 24 Sep 2018 15:54:19 GMT

Thank you Reeza, that is super straightforward. Thank you for your help!