topic Re: Date format in Data Step comparison in SAS Programming

Date format in Data Step comparison

Crubal — Tue, 25 Apr 2017 15:01:32 GMT

Hi,

I would like to filter out 'Stay_Date' before today. How could I change the following code in Data step?

Data Work.A;

Set Work.B;

Where Stay_Date LE 'sysdate'd;

Run;

It returns error: Invalid Date / Time. As 'Stay_Date' format is '2015-12-31'. But the following code is fine:

Data Work.A;

Set Work.B;

Where Stay_Date LE '25APR2017'd;

Run;

How could I use System date instead of a particular one? Thank you!

Re: Date format in Data Step comparison

Astounding — Tue, 25 Apr 2017 15:08:26 GMT

A couple of small changes:

Where Stay_Date LE "&sysdate9"d;

It's important to use double quotes, so that the macro variable can resolve.

Re: Date format in Data Step comparison

PaigeMiller — Tue, 25 Apr 2017 15:12:59 GMT

@Crubal wrote:

It returns error: Invalid Date / Time. As 'Stay_Date' format is '2015-12-31'

It seems you are confusing a few issues here. Stay_Date (without the quotes) is 2015-12-31 without the quotes, and this is a formatted date value, it is not a character string (which is what the quotes would indicate). Thus you need to compare Stay_Date to a SAS date value, for example:

where stay_date le today();

No need for macro variables, or double-quotes to all the macro variable to be resolved.

Re: Date format in Data Step comparison

Crubal — Tue, 25 Apr 2017 15:24:11 GMT

Thank you that would be helpful for future Macro procedure!