Error: Expression using not equals (^=) has components that are of different data types.

GN0001 — Sat, 03 Jul 2021 06:21:08 GMT

Hello team,

This refers to the lines that I have case statements.

Regards,

blue blue

Re: Error: Expression using not equals (^=) has components that are of different data types.

Patrick — Sun, 04 Jul 2021 03:19:17 GMT

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.

topic Error: Expression using not equals (^=) has components that are of different data types. in SAS Programming

Error: Expression using not equals (^=) has components that are of different data types.

Re: Error: Expression using not equals (^=) has components that are of different data types.