Referencing datasets and proc sql create table query

[jeremy4]

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;

[Astounding · Accepted solution]

Remove 5 characters from PROC SQL:

data=

That should correct both errors.

[jeremy4]

Thanks for your help!