topic Date Comparison in a Macro in SAS Programming

Date Comparison in a Macro

deleted_user — Thu, 13 Aug 2009 15:02:38 GMT

Hi All:

I'm trying to compare two dates in a macro and I'm getting the error message:

ERROR: Required operator not found in expression: input("&enddate",yymmdd8.) < intnx('year',input("&startdate",yymmdd8.),0,'end')

The statement that's causing the error is this:

%if input("&enddate",yymmdd8.) < intnx('year',input(&startdate",yymmdd8.),0,'end') %then
%do;
...other stuff...

Here, enddate = 20090331. I've done comparisons like this in the past and have never had an error like this. I'm sure I'm overlooking something very basic.

Thanks,

T.M. Foy

Re: Date Comparison in a Macro

sbb — Thu, 13 Aug 2009 15:12:42 GMT

You will need to explore using the %SYSFUNC macro language function when you want to integrate SAS CALL functions into macro language coding.

Scott Barry
SBBWorks, Inc.

Re: Date Comparison in a Macro

deleted_user — Thu, 13 Aug 2009 15:18:28 GMT

Thanks, I'll try that.