topic Expression using ng equals has different data types in SAS Programming

Expression using ng equals has different data types

Chandra6 — Mon, 03 Apr 2023 19:33:25 GMT

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

Re: Expression using ng equals has different data types

ballardw — Mon, 03 Apr 2023 19:54:11 GMT

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

Re: Expression using ng equals has different data types

PaigeMiller — Mon, 03 Apr 2023 20:54:14 GMT

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