Referencing datasets and proc sql create table query

jeremy4 — Fri, 03 May 2019 10:48:08 GMT

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;

Re: Referencing datasets and proc sql create table query

Astounding — Fri, 03 May 2019 10:48:37 GMT

Remove 5 characters from PROC SQL:

data=

That should correct both errors.

Re: Referencing datasets and proc sql create table query

jeremy4 — Fri, 03 May 2019 11:12:58 GMT

Thanks for your help!

topic Referencing datasets and proc sql create table query in SAS Programming

Referencing datasets and proc sql create table query

Re: Referencing datasets and proc sql create table query

Re: Referencing datasets and proc sql create table query