topic Re: When date is not a date in SAS Procedures

When date is not a date

BETO — Wed, 18 Jun 2014 19:54:25 GMT

I m pulling data from a SQL server and the date is coming in formatted date9. ...the issue that I'm having is that i need to bring in whole records I tried filtering for yesterday date but I get error message saying = is different kind of data sets.
when I ping the original table I can filter the same colmn by date.... Thank you for any assistance

Re: When date is not a date

Fugue — Wed, 18 Jun 2014 20:06:16 GMT

What method are you using to pull the data? Are you licensed for SAS Access to Microsoft SQL Server? Which version of SAS? Can you provide a sample of code?

Note that SAS Access has default behaviour when converting dates/times. Also, there may be options that you can set that will affect how data types are handled by SAS (e.g. SASDATEFMT or DBASTYPE).

Re: When date is not a date

SASKiwi — Wed, 18 Jun 2014 22:34:38 GMT

SQL Server usually holds dates as datetimes. If you filter in SQL Server by date it probably knows how to handle this correctly: where date = '2014-01-01'

Filtering in SAS on a table with the same date read from SQL Server would probably require a datetime string: "01jan2014:00:00:00'dt.

Please provide an example of your problem so we can advise further.