Not missing statement is running successfully but not getting the output

Sandeep77 — Wed, 29 Jun 2022 09:35:33 GMT

Hi Experts,

I am trying to find where the date is not missing and running the code. The code runs successfully but there is not output. Can you please check and let me know what is the mistake I am making? There is nothing in the result and output tab.

proc sql;
create table confirmed_email as
select a.*,
b.emailaddress,
b.confirmeddate
from Live_phone_numbers as a 
inner join p2scflow.emailaddress as b on a.Accounts_number = b.debt_code
where b.confirmeddate is not missing;
quit;

LOG:

29         proc sql;
30         create table confirmed_email as
31         select a.*,
32         b.emailaddress,
33         b.confirmeddate
34         from Live_phone_numbers as a
35         inner join p2scflow.emailaddress as b on a.Accounts_number = b.debt_code
36         where b.confirmeddate is not missing;
NOTE: Compressing data set WORK.CONFIRMED_EMAIL decreased size by 91.42 percent. 
      Compressed is 1009 pages; un-compressed would require 11766 pages.
NOTE: Table WORK.CONFIRMED_EMAIL created, with 482398 rows and 13 columns.

37         quit;
NOTE: PROCEDURE SQL used (Total process time):

Re: Not missing statement is running successfully but not getting the output

andreas_lds — Wed, 29 Jun 2022 09:54:00 GMT

Check the library "work" a dataset named confirmed_email should be there.

Re: Not missing statement is running successfully but not getting the output

Sandeep77 — Wed, 29 Jun 2022 10:36:19 GMT

I changed from work.Live_phone_numbers as a instead of just from Live_phone_numbers as a
and that worked. Thanks again!

topic Re: Not missing statement is running successfully but not getting the output in New SAS User

Not missing statement is running successfully but not getting the output

Re: Not missing statement is running successfully but not getting the output

Re: Not missing statement is running successfully but not getting the output