topic Date variable in SQL Server in SAS Programming

Date variable in SQL Server

sarahzhou — Wed, 09 Nov 2022 07:31:10 GMT

Hi,

I encounter a problem when querying a data range in SQL server, when the comparison is less than a 'date', it went wrong. However, when a date is equal to a 'date' it works.

the blow query has an error;

proc sql noprint;
connect to sqlver as myserver (darasrc="share_data" authdomain="nopassword");
create table class_schedule as sellect * from connect to myserver 
(select * from table_classA where class_date <'01NOV2022');
disconnect from sqltgt;
quit;

the blow query has no errors;

proc sql noprint;
connect to sqlver as myserver (darasrc="share_data" authdomain="nopassword");
create table class_schedule as sellect * from connect to myserver 
(select * from table_classA where class_date ='01NOV2022');
disconnect from sqltgt;
quit;

But, I am interested in selecting the data less than a date, I need to use the "<" sign. How can I achieve that?

Kindly help.

Thank you!

Re: data variable in sql server

sarahzhou — Wed, 09 Nov 2022 03:47:24 GMT

I found the problem. Thanks, pls ignore.

Re: data variable in sql server

LinusH — Wed, 09 Nov 2022 07:32:23 GMT

Or, tell us how you solved it for the benefit of others.

Re: Date variable in SQL Server

Kurt_Bremser — Wed, 09 Nov 2022 12:01:19 GMT

I guess that SQL Server does not like the SAS date literal notation when the "smaller as" operator is used.

Re: Date variable in SQL Server

sarahzhou — Mon, 14 Nov 2022 03:20:20 GMT

Thank you @Kurt_Bremser