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

[GN0001]

Hello team,

This refers to the lines that I have case statements.

Regards,

blue blue

[Patrick]

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.