topic Read SQL date which is in text format in SAS Programming

Read SQL date which is in text format

Stalk — Tue, 02 Mar 2021 22:55:58 GMT

I have SQL date time field that downloaded as text field.
03/01/2021 11:35
used the following code to read..
input(trans_Date,anydtdtm.) as Date_Transfered format=dtdate9.,
but when I try to query the data :

where Date_Transfered >= '01MAR2021'd; where clause is not working and it's pulling all the observations.

What did I miss?

Thank you

Re: Read SQL date which is in text format

ChrisNZ — Tue, 02 Mar 2021 23:10:16 GMT

You do a god jobs of transforming the string into a datetime.

That means you must filter on a datetime value:

datepart(DATE_TRANSFERED) >= '01MAR2021'd;

or (better)

DATE_TRANSFERED >= '01MAR2021:00:00:00'dt;

Hint: look at the unformatted values when in doubt.

Re: Read SQL date which is in text format

Stalk — Tue, 02 Mar 2021 23:56:33 GMT

Thank you. It works.