topic PROC SQL Error Message in SAS Programming

PROC SQL Error Message

KC_16 — Tue, 19 Nov 2019 16:00:43 GMT

Hi,

I have the following error message, any idea how I would resolve please?

ERROR: The Equality operator must compare operands of the same type

proc sql ;
create table work.apps as
select
a.*,
b.income, b.date
from work.comps as a left join work.apps_ytd as b
on a.id = b.urn;
quit;

novinosrin — Tue, 19 Nov 2019 16:04:13 GMT

It seems ID and urn are not of the same datatypes. Please do proc contents of both and let us know which one is which

Shmuel — Tue, 19 Nov 2019 16:10:46 GMT

In your condition on a.id = b.urn both side should be of same type, either numeric or alphanumeric.

assuming a.id is numeric and b.urn contains digits you can replace condition into:

a.id = input(b.urn , best.) thus transforming the alphanumeric into numeric.

Kurt_Bremser — Tue, 19 Nov 2019 16:13:41 GMT

Since id and urn are used for a join, I deduct they are not needed for calculations, so they should both be character.