topic Regular expressions applied to macros variables in ODS and Base Reporting

Regular expressions applied to macros variables

JuanVte — Tue, 17 Nov 2009 11:32:46 GMT

Hi everyone,

I would like to validate that a macro variable contents a numeric value.

I can do that with regular expresion in a data step but I do not know the way to do it with a macro variable.

%let var = 123;
%is_numeric(var);

is_numeric should return true

%let var = abc;
%is_numeric(var);

is_numeric should return false.

Could somebody help me??

Thanks!!
sincerely, Juanvte.

Re: Regular expressions applied to macros variables

S_E_N_T_H_I_L — Tue, 17 Nov 2009 11:51:16 GMT

Hi Juanvte,

Hope I understood.

If it is correct, you can get it by SCAN & INDEX function.

In the INDEX, you search for (0123456789) if its falls then its numeric.

Please correct, if it is falls.

Regards,

S E N T H I L

Re: Regular expressions applied to macros variables

sbb — Tue, 17 Nov 2009 14:06:57 GMT

Also, check the ANYxxxx functions which came about with SAS 9, such as ANYDIGIT. With macro language, you also must use %SYSFUNC along with the call function.

Scott Barry
SBBWorks, Inc.

SAS Language Reference: Dictionary, Using Functions and CALL Routines
http://support.sas.com/documentation/cdl/en/lrdict/62618/HTML/default/a001281551.htm