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.
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;
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;
Haha. Everything I tried unsuccessfully was much more complicated than what you
suggest. A good lesson in that...It worked just as needed. Thanks!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: