topic How to write date in New SAS User

How to write date

Kirito1 — Mon, 26 Dec 2022 06:56:44 GMT

The below code is throwing an error as below:

Invalid date/time/datetime constant '01-09-2022:00:00:00am'dt.

proc sql;
create table dummy as 
Select * from MR
where 'Date Of approval'n GE '01-09-2022:00:00:00am'dt. AND 'Date Of approval'n LE '30-11-2022:00:00:00am'dt.;
quit;

How should I proceed?

Re: How to write date

Kurt_Bremser — Mon, 26 Dec 2022 08:34:34 GMT

The date in a datetime literal must be written in the same DATE9. format like a date literal, e.g. '01jan1960:00:00:00'dt. Do not use am/pm, but 24-hour notation.

Re: How to write date

Kirito1 — Mon, 26 Dec 2022 09:13:12 GMT

So, does that mean its a limitation for me as the data I have is in ddmmyy format. So, I first have to convert that data in date9 format in excel and then use it as my data.
That's really tedious.
BTW thanks for the solution kindly suggest if there are any other alternative.

Re: How to write date

Kurt_Bremser — Mon, 26 Dec 2022 09:21:09 GMT

If you have SAS datetime values, the display format is irrelevant, as the underlying raw values are counts of seconds, starting at 1960-01-01T00:00:00.

If you do not have SAS datetimes, but character strings, these must be converted first. This should be done when the data is imported into SAS.