Hi,
How can I delete those observations in table A that are all contained in table B,that is, I don't want all those observations of table B to present in table A.
Thanks!
Probably the simplest way is:
proc sql;
create table C as
select * from A except all corr select * from B;
drop table A;
quit;
PG
Data step alternative:
proc sort data= | table1;by _all_ ; |
proc sort data= | table2;by _all_ ; run; |
data table3;
merge table1(in=a) table2(in=b);
by _all_ ;
if a and not b;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.