topic From statement error in New SAS User

From statement error

Sandeep77 — Tue, 31 May 2022 14:17:09 GMT

I am trying to get a data from the previous table using from statement but getting error. Please suggest experts.

proc sql;
create table Test AS
Select
Account_code
From work.'foreign address'n;
quit;


proc sql;
create table Add_repcode as 
select a.*,
b.rep_code,
From Test
inner join p2scflow.debt as b on a.Account_code= b.Account_code;
quit;

Getting this error

30         proc sql;
31         create table Add_repcode as
32         select a.*,
33         b.rep_code,
34         From Test
                _________________
                79
ERROR 79-322: Expecting a FROM.

35         inner join p2scflow.debt as b on a.account_code = b.account_code ;
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
36         quit;

Re: From statement error

Tom — Tue, 31 May 2022 14:25:08 GMT

You have an extra comma.

Make sure that you define the aliases if you are going to use them to reference variables from specific input dataset.

Do not hide continuation characters at the END of the line. Place them at the BEGINNING of the line. It is much easier for humans to scan for them there.

proc sql;
create table Add_repcode as 
  select a.*
       , b.rep_code
  from Test as a
   inner join p2scflow.debt as b
    on a.Account_code= b.Account_code
;
quit;

Re: From statement error

AMSAS — Tue, 31 May 2022 14:27:55 GMT

What @Tom points out is the comma at the end of line 4 (see my comment) is the cause of your error. Delete that comma and problem solved

proc sql;
create table Add_repcode as 
select a.*,
b.rep_code, /* This comma at the end of this line is the issue */
From Test
inner join p2scflow.debt as b on a.Account_code= b.Account_code;
quit;

Re: From statement error

Sandeep77 — Tue, 31 May 2022 14:38:41 GMT

I did tried doing that but it gave me unresolved reference and few more errors.

9         proc sql;
30         create table Add_repcode as
31         select a.*,
32         b.rep_code
33         From Test
34         inner join p2scflow.debt as b on a.account_code = b.account_code ;
ERROR: Unresolved reference to table/correlation name a.
ERROR: Could not expand a.*, correlation name not found.
ERROR: The following columns were not found in the contributing tables: a.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
35         quit;
NOTE: The SAS System stopped processing this step because of errors.

Re: From statement error

PaigeMiller — Tue, 31 May 2022 15:18:13 GMT

Because you have additional errors that become prominent once the comma is removed.

ERROR: Unresolved reference to table/correlation name a.

You don't have a table referred to with the alias A. So you can't use

select a.*,

I believe the fix is obvious, so I leave it as a homework assignment for you.