topic Re: date comparison condition in a macro in SAS Programming

date comparison condition in a macro

sfmeier — Wed, 16 May 2012 10:00:32 GMT

I am trying to create a macro bibgen, that sets the macro variable bib to a, if the date stichdatum is earlier then 01Jan2012, else to b.

Stichdatum is a date macro variable that is created by the code

--------------------------------------------------------

%LET &

%LET Stichdatum = %sysfunc(INPUTN(&stichtag, B8601DA.));

--------------------------------------------------------

Here is my macro, however it does not work. It always returns b, whereas it should return b in this case! How can I fix it?

--------------------------------------------------------

/* Makro zur automatischen Selektion der richtigen Bibliothek wg. Historisierung */

%Macro bibgen();

%GLOBAL bib;

%LET stichdatum2 = %SYSFUNC(putn(&stichdatum, date9.));

%PUT stichdatum=&stichdatum;

%PUT stichdatum2=&stichdatum2;

%IF &stichdatum < '01Jan2012'd

%THEN %LET bib =a;

%ELSE %LET bib =b;

%PUT &bib;

%mend bibGen;

Re: date comparison condition in a macro

sfmeier — Wed, 16 May 2012 10:01:23 GMT

The first line must be

%LET &stichtag=20111230;

Re: date comparison condition in a macro

PaulLee — Wed, 16 May 2012 10:26:27 GMT

Rather than writing the date as '01Jan2012'd, that will just be interpereated as text? Use this instead...

%sysfunc(putn('01Jan2012'd,5.))

Re: date comparison condition in a macro

sfmeier — Wed, 16 May 2012 10:56:40 GMT

Thank you! It works. However, just that I understand the reason: I always thought that SAS would evaluate the condition as sas code and not as macro code.

So would the condition be different in an regular IF-THEN-Clause? i.e.I could write '01Jan2012'd in a regular IF-THEN-Clause, coundn't I?

Re: date comparison condition in a macro

Tom — Wed, 16 May 2012 10:58:32 GMT

Use %SYSEVALF() to let the macro code evaluate the date comparisons.

%IF %sysevalf(&stichdatum < '01Jan2012'd)