09-11-2013 05:16 PM
Hi, I am trying to query a Sybase table in SAS using proc sql, and I want set a condition in my query on the datetime field. When I do this get the error message
"ERROR: Expression using equals (=) has components that are of different data types."
My proc looks like this:
create table *** as
where datefield = '8/20/2013 12:00:00.000 AM';
Does anyone know how to work around this error message? I have tride datetime(datefield) but it does not work.
Thanks a bunch,