Expression using ng equals has different data types

[Chandra6]

Proc sql ;
create table CIR_TRV_BUREAU _&MISDATE._6 AS
SELECT A. *, B. PHASE1_2_ELIGIBLE
FROM ABC.CIR_TRV AS à
Left join(select distinct crn, 1 as phase1_2 eligible from abc. Bureau) as b on a. Crn_n=b.crn; quit;
Regina

[ballardw]

Run proc contents on BOTH data sets and compare the variable type. In one the variable will be character in the other numeric.

If Crn_n has the _n to indicate a numeric version then I might guess that Crn in B is character.

Join on variables have to be the same type.

Note that your code as posted:

FROM ABC.CIR_TRV AS à

with the accent over the a is also likely to be invalid syntax.

---

@Chandra6 wrote:
Proc sql ;
create table CIR_TRV_BUREAU _&MISDATE._6 AS
SELECT A. *, B. PHASE1_2_ELIGIBLE
FROM ABC.CIR_TRV AS à
Left join(select distinct crn, 1 as phase1_2 eligible from abc. Bureau) as b on a. Crn_n=b.crn; quit;
Regina

---

[PaigeMiller]

Show us the ENTIRE log for this PROC SQL, not just the error messages.