Hello team,
This refers to the lines that I have case statements.
Regards,
blue blue
You get such a message if you formulate a comparison between a column of type character and a column of type numeric.
You can only compare variables of the same data type (numeric with numeric or character with character).
Run a Proc Contents over your table and the report will show you one of the columns as char and one as num.
You have to convert one of the columns to the other type: i.e. put(<numerical column>,32.) to create a string of digits to compare with another variable which contains similar string of digits.
If you formulated a comparison variable=<some value> then make sure that if your variable is of type character the value is in quotes, and if the variable is of type numeric then not quotes around the value.
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: