How to write this proc to a table

[carmendee]

proc sql;
   title 'Updated MLPs';
   select * from WORK.IDENTIFY_INACTIVE_MLP_YESTERDAY
   except    
   select * from WORK.MLP_RECORDS_2_ADD_UPDATE;
  

Need the results to create a table?!

[Reeza]

Then tell it to create a table 😉

proc sql;
   title 'Updated MLPs';

create table want as select * from (
   select * from WORK.IDENTIFY_INACTIVE_MLP_YESTERDAY
   except    
   select * from WORK.MLP_RECORDS_2_ADD_UPDATE);

[mohamed_zaki · Accepted solution]

proc sql;
CREATE TABLE except AS

select * from WORK.IDENTIFY_INACTIVE_MLP_YESTERDAY
except    
select * from WORK.MLP_RECORDS_2_ADD_UPDATE;
  

[RW9]

Please note, the title is not needed as there is no printed output with create table, and please finish code blocks:

proc sql;
   create table WANT as
   select * from WORK.IDENTIFY_INACTIVE_MLP_YESTERDAY
   except    
   select * from WORK.MLP_RECORDS_2_ADD_UPDATE;
quit;