Help using Base SAS procedures

Use minus in proc sql

Super Contributor
Posts: 409

Use minus in proc sql

Hi, as you can see I'm not that familiar with proc sql, but how can I subtract the results from one table from another table?  using minus.?

If I have table A with 20,000 records and table B a subsidiary of A with 12,000, I want to get Table C with the remaining 18,000 recods.. in PROC SQL Thanks

Respected Advisor
Posts: 3,167

Re: Use minus in proc sql

Use 'except':

proc sql;

create table c as

   select * from a


  select * from b;

I suppose that you had a typo in your post: B has 2000 obs instead of 12000.


Ask a Question
Discussion stats
  • 1 reply
  • 1 like
  • 2 in conversation