Hi,
I have written the following code but I have two error messages (highlighted in red below) when:
(1) trying to reference the dataset in the proc sql left join and
(2) when i try to reference the proc sql create table to use for the proc freq.
Can someone please help me out so that I can correctly reference the dataset for the proc sql section and how to reference the table that has been created using proc sql in order to comlete the proc freq section? Thanks.
data account_analysis;
set rc.accounts_missing;
run;
proc sql;
create table portfolio_subsegment_split as
select a.account_ID, a.month_end, a.utilisation, b.portfolio_subsegment
from data=account_analysis as a
left join mod.output_v_2019 as b
on a.account_id = b.account_id and a.month_end = b.month_end
;
quit;
proc freq data=portfolio_subsegment_split;
tables portfolio_subsegment*utilisation / nocum out=want;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.