Inner join

[Sandeep77]

Hello Experts,

I am trying to join Test_1 with Test_2 table with common client_code which is available in both the table but getting below error: 

NOTE: Writing HTML5(EGHTML) Body file: EGHTML
28
29 proc sql;
30 create table Test_2 as
31 select a.*,
32 b.cl_name,
33 b.client_code
34 from Test_1 as a
35 inner join p2scflow.client as b on a.client_code = b.client_code;
ERROR: Column client_code could not be found in the table/view identified with the correlation name A.
ERROR: Column client_code could not be found in the table/view identified with the correlation name A.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
36 quit;
NOTE: The SAS System stopped processing this step because of errors.

Not sure why it is throwing this error message. Can you please suggest what I am doing wrong here?

[Kurt_Bremser]

The message is clear: there is no variable named client_code in dataset work.test_1. Run a PROC CONTENTS on the dataset to see what it contains.

Also make sure that all preceding steps designed to create test_1 have run successfully (no ERRORs, WARNINGs or NOTEs beyond those that inform about CPU utilization and resulting dataset size).

[ballardw]

I'm going to make a small wager that if you have a "client code" variable in data set Test_1 that it is spelled differently. Possibly "clientcode" no underscore, or maybe "client__code" with two underscores or possibly and abbreviation like "clnt_code".

Especially if one or more of these data sets comes from something created by Proc Import or the wizards that use that procedure in the background variables names are subject to change on the whim of file creators.