I have two tables. I want to delete from table A observations of table B
Table 1
A B
3 5
4 6
1 2
3 4
Table 2
A B
3 5
3 4
Table want
A B
4 6
1 2
If you have two values of A=3 and B=5 in table 1 do you want all of them gone?
Does the final order of the results matter?
If the answer to the first question is yes and no to the second then:
proc sql;
create table want as
select * from table1
except
select * from table2
quit;
Will work.
If you have lots of other variables then additional work will be needed.
If you have two values of A=3 and B=5 in table 1 do you want all of them gone?
Does the final order of the results matter?
If the answer to the first question is yes and no to the second then:
proc sql;
create table want as
select * from table1
except
select * from table2
quit;
Will work.
If you have lots of other variables then additional work will be needed.
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.