topic Re: How to write this proc to a table in SAS Enterprise Guide

How to write this proc to a table

carmendee — Wed, 09 Dec 2015 21:37:31 GMT

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?!

Re: How to write this proc to a table

Reeza — Wed, 09 Dec 2015 21:58:44 GMT

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);

Re: How to write this proc to a table

mohamed_zaki — Wed, 09 Dec 2015 21:59:04 GMT

proc sql;
CREATE TABLE except AS

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

Re: How to write this proc to a table

RW9 — Thu, 10 Dec 2015 09:47:58 GMT

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;