Not missing statement is running successfully but not getting the output

[Sandeep77]

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

[andreas_lds · Accepted solution]

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

[Sandeep77]

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