topic Re: How to create ">" in a macro? in SAS Programming

How to create ">" in a macro?

sfmeier — Tue, 22 May 2012 15:36:20 GMT

I am using

%SYSFUNC(cats(&number,_,'>',%SYSFUNC(Intnx(year, &dvar, -1, end), DDMMYYP10.)))

in a Macro to create the text

14_>31.12.2018

However, I get the error:

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

NOTE: Line generated by the macro function "SYSFUNC".

23 14_'>'31.12.2018

___

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

How can I eliminate the error?

Re: How to create ">" in a macro?

JasonDiVirgilio — Tue, 22 May 2012 19:49:49 GMT

Try %str(>) instead of single quotes in a macro.

%SYSFUNC(cats(&number,_,%str(>),%SYSFUNC(Intnx(year, &dvar, -1, end), DDMMYYP10.)));

Re: How to create ">" in a macro?

chang_y_chung_hotmail_com — Tue, 22 May 2012 20:55:15 GMT

Hope this helps a bit. Good luck!

%*-- cats() called through %sysfunc() seems to evaluate > as a logical expression
even when macro quoted. ran on 9.3 ts1m0 on w32_7pro --*;
%put %sysfunc(cats(***,%str(>),***));
%*-- on log -- 0 since null(nothing) is not greater than another null.
***0***
--*;

%*-- but we do not need cats for string concatenation in macro --*;
%let number = 14;
%let date = %sysfunc(today());

%let ldopy = %sysfunc(intnx(year, &date, -1, end), DDMMYYP10.);
%put last day of previous year = &ldopy;

%put &number._>&ldopy;
%*-- on log
14_>31.12.2011
--*;

Re: How to create ">" in a macro?

dbiehle — Tue, 22 May 2012 22:09:19 GMT

Agree with chang_y_chung: just try without CATS.

Your code:

%SYSFUNC(cats(&number,_,'>',%SYSFUNC(Intnx(year, &dvar, -1, end), DDMMYYP10.)))

Edited code:

&number_>%SYSFUNC(Intnx(year, &dvar, -1, end), DDMMYYP10.)

Re: How to create ">" in a macro?

sfmeier — Wed, 23 May 2012 13:29:42 GMT

Ok thx, it works!