topic Re: Removing information from a dataset that is contained elsewhere in SAS Data Management

Removing information from a dataset that is contained elsewhere

mphqueens — Fri, 10 Jun 2016 19:45:21 GMT

I have two data sets, A and B. A is larger and contains all the same information as B plus extra (B was created from A using proc sql - selecting distinct observations). I would like to remove everything that is contained in data set B from data set A to have two distinct sets with no duplicate variables.

How would I go about this?

Re: Removing information from a dataset that is contained elsewhere

jklaverstijn — Fri, 10 Jun 2016 19:58:48 GMT

How about this

Proc sql;
Create table c as
Select * from a where nog exists (select * from b);
Quit;

Re: Removing information from a dataset that is contained elsewhere

ballardw — Fri, 10 Jun 2016 21:48:52 GMT

If all the variables are the same

Proc sql;
   create table want as
   select * from A
   except
   select * from B
   ;
quit;

I think @jklaverstijn may have meant NOT instead of NOG