error message on a sql query

[dimpu79]

Hi,
I am a starter
When i am writing the following program i am getting the following error in the log.
code:
proc sql;
select *
from sashelp.class
where age='14';
quit;
log message:
49 proc sql;
50 select *
51 from sashelp.class
52 where age='14';
ERROR: Expression using equals (=) has components that are of different data types.
53 quit;
Thanks in advance for your help.

 

[klaz2002]

Take the single quotes out of your age=14 statement. What you told SAS to do was find all the records in the character var age that has a 14. This is incorrect as age is a numeric var.
Klaz

I hope that this helped you.