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

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

almmotamedi — Thu, 28 Jan 2016 20:11:27 GMT

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')

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

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

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

QUIT;

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

Reeza — Thu, 28 Jan 2016 20:18:44 GMT

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)

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

almmotamedi — Thu, 28 Jan 2016 20:31:40 GMT

It worked! Thank you so mcuh

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

ballardw — Thu, 28 Jan 2016 21:44:28 GMT

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