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;
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)
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)
It worked! Thank you so mcuh
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: