topic Re: ERROR: Expression using equals (=) has components that are of different data types. in SAS Enterprise Guide

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

sasuser55 — Fri, 19 Mar 2021 18:27:19 GMT

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.

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

Amir — Fri, 19 Mar 2021 18:45:58 GMT

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.

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

Astounding — Fri, 19 Mar 2021 19:49:00 GMT

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.