Create a data set from a PROC SQL

crawfe — Sat, 06 Jul 2019 12:07:11 GMT

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.

Re: Create a data set from a PROC SQL

Ksharp — Sat, 06 Jul 2019 12:15:22 GMT

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 — Sat, 06 Jul 2019 13:31:41 GMT

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

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