topic ERROR: Expression using equals (=) has components that are of different data types. in New SAS User

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

mokleber — Thu, 22 Sep 2022 23:44:15 GMT

I am very new to SAS as I am learning it currently for a college course. I am getting this error, "ERROR: Expression using equals (=) has components that are of different data types.", with the following code;

libname mk "/home/u62148011/sasuser.v94";
run;

proc contents data= mk.aha;
run;

PROC SQL;
CREATE TABLE WORK.query AS
SELECT PHAGMISS

FROM mk.aha

ORDER BY PHAGMISS= "5";
RUN;
QUIT;

I believe the error is occurring with the ORDER BY statement. Any advice or help you can give would be great.

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

ballardw — Thu, 22 Sep 2022 23:56:49 GMT

It would appear that your variable PHAGMISS is numeric.

Look at your Proc Contents output. Does it show NUM as Type for that variable? Num means numeric in Proc Contents type values.

Why do you have an = on the Order by anyway? Do you want the records where Phagmiss=5 to be at the end?

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

Kurt_Bremser — Fri, 23 Sep 2022 02:53:35 GMT

ORDER BY PHAGMISS= "5";

PHAGMISS seems to be numeric.

Your ORDER BY value is the result of a comparison, so the ORDER BY clause will put all the 5's at the end of the resulting dataset. Is this what you want?