topic Error 73-322 expecting an on in SAS Programming

Error 73-322 expecting an on

req41273 — Thu, 22 Aug 2019 19:49:08 GMT

Any help on why this error 73-322 is generating?


                                        _
proc sql noprint;
121        create table MBR as
122        select a.*, b.description as PROV_SPECIALTY_DESCRIP
123        from MBR a left join sasave.prov_type_master_map to_prov_spe b
                                                                        _
                                                                        73
                                                                        76
ERROR 73-322: Expecting an ON.

ERROR 76-322: Syntax error, statement will be ignored.

124        on a.prov_specialty_type = b.type_or_spec_code;
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
125        quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      
126        run;
127        


128        data MBR(drop=PROV_SPECIALTY_DESCRIP);
129         set MBR;
130        
131         description=PROV_SPECIALTY_DESCRIP;
132         run;                                                                        
                                                                        76

Re: Error 73-322 expecting an on

PaigeMiller — Thu, 22 Aug 2019 20:19:32 GMT

Perhaps you need something like this

from MBR a left join sasave.prov_type_master_map b
on a.variablename=b.variablename

After the second data set name of a left join (in this case sasave.prov_type_master_map), you must use the ON clause at that point (or you can have an alias followed by the ON clause). Your text there:

to_prov_spe

isn't allowed, this isn't an alias and it isn't an ON clause.

Re: Error 73-322 expecting an on

r_behata — Thu, 22 Aug 2019 20:03:49 GMT

Review the line below, it seems to have an unexpected space between "_map to"

left join sasave.prov_type_master_map to_prov_spe b

Re: Error 73-322 expecting an on

req41273 — Fri, 23 Aug 2019 15:59:18 GMT

Thanks. I made the change accordingly using a.variablename=b.variablename. It works. Is there a way I can modified the line of SAS code to drop set ( include) a second variable on table b?

Re: Error 73-322 expecting an on

Tom — Fri, 23 Aug 2019 16:25:16 GMT

The list of variables being created/output is located between the SELECT and the FROM keywords.

select 
  a.*
, b.var1
, b.var2
from

Re: Error 73-322 expecting an on

req41273 — Fri, 23 Aug 2019 16:32:15 GMT

Thanks, this worked.

Re: Error 73-322 expecting an on

req41273 — Fri, 23 Aug 2019 16:32:33 GMT

Thanks.