ERROR: Expression using equals (=) has components that are of different data types.

[sasuser55]

I am attempting to join two tables on three different variables - 1 char and 2 numeric variables. The respective variables from each table match the variable type, as confirmed by proc contents, but i am still receiving the error message that they do not match.

[Amir]

Hi @sasuser55,

Please share the code and the proc contents using the "Insert code" icon ("</>") to give a box to paste the details into.

This should help others to make suggestions you can try.

Kind regards,

Amir.

[Astounding]

If the contents showed a difference, you would get a different error message than the one you actually got.  This one is (keep in mind we are guessing because you kept the code itself a secret) more like you subset the data with:

where statecode="20"

when statecode is actually a numeric variable.  So you will have to show the program if you want real help.