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

[almmotamedi]

Could you please help with this error?, I checked my variables on both sides of the "=" signs and they seem to be match. However, I still get the error!

SprCreditType_0001 ---> character

ConstClass_0002 ---> numeric

PROC SQL;

.

.

.

WHERE (t1.SprCreditType_0001 = 'P' AND t1.ConstClass_0002 = '5')

OR

(t1.SprCreditType_0001 = 'N' AND t1.ConstClass_0002 = '5')

OR 

(t1.SprCreditType_0001 = 'P' AND t1.ConstClass_0002 = '6')

OR

(t1.SprCreditType_0001 = 'N' AND t1.ConstClass_0002 = '6') ;

QUIT;

[Reeza · Accepted solution]

If ConstClass_0002 is numeric the numbers should not be in quotes, quotes are for character variables.

WHERE (t1.SprCreditType_0001 = 'P' AND t1.ConstClass_0002 = 5)

[almmotamedi]

It worked! Thank you so mcuh 

[ballardw]

Also consider"
WHERE (t1.SprCreditType_0001 in ( 'P' ,'N') AND t1.ConstClass_0002 in (5, 6) )