Create a data set from a PROC SQL

[crawfe]

Hi. I am rather new to SAS programming. I need to get the result from a PROC SQL into an interim data set that I can process further. 

I got this PROC to give the Report below, after joining two small tables.

proc sql;

select FullMonthListMY, Go_LIVE_MNTH, Count
from WORK.FULL_CALENDAR_LIST LEFT JOIN CDTEMP8
ON FullMonthListMY=Go_LIVE_MNTH;

run;

Output Report:

FullMonthListMY   Go_LIVE_MNTH   Frequency Count

12/2017                       12/2017                    1

12/2017                        12/2017                   8

02/2018                              .                         .

03/2018                              .                         .

(etc)...

Two questions:

1. Can I replace all blanks with zero (numeric) in Frequency Count using code within this PROC.

2. How do I get this result out into an interim Dataset rather than a Report for further use. 

Thanks!I hope this is enough to give you the idea of what I am after.

[Ksharp · Accepted solution]

proc sql;

create table want as

select FullMonthListMY, Go_LIVE_MNTH,    coalesce(Count,0) as Count
from WORK.FULL_CALENDAR_LIST LEFT JOIN CDTEMP8
ON FullMonthListMY=Go_LIVE_MNTH;

quit;

[crawfe]

Haha. Everything I tried unsuccessfully was much more complicated than what you

suggest. A good lesson in that...It worked just as needed. Thanks!