topic Re: How to judge whether a maro variable is a pure numeric in SAS Procedures

How to judge whether a maro variable is a pure numeric

Mike_Davis — Fri, 24 Aug 2012 16:49:33 GMT

Hello everyone,

I want to know whether a macro variable is a pure numeric or it include some characters, how to do this?

For example:the macro variable &notpure is NOT a pure numeric, it includes some characters('aqw').how to know this?

%let notpure=123aqw4567;

%let pure=12345;

Thanks

Mike

Re: How to judge whether a maro variable is a pure numeric

art297 — Fri, 24 Aug 2012 17:21:28 GMT

%let notpure=123aqw4567;

%put %sysfunc(notdigit(&notpure.));

%let pure=12345;

%put %sysfunc(notdigit(&pure.));

Re: How to judge whether a maro variable is a pure numeric

Mike_Davis — Fri, 24 Aug 2012 17:42:46 GMT

Awesome,

Thanks Art!

Mike

Re: How to judge whether a maro variable is a pure numeric

Tom — Fri, 24 Aug 2012 17:43:07 GMT

Why not use the SAS supplied macro DATATYP ?

Re: How to judge whether a maro variable is a pure numeric

Mike_Davis — Mon, 27 Aug 2012 17:51:56 GMT

Thank you Tom!

%macro test;
%let a=123;
%let b=a12;
%put 1:%DATATYP(&a);
%put 2:%DATATYP(&b);
%if %DATATYP(&b)=CHAR %then %put char;
%if %DATATYP(&b)=NUMERIC %then %put #;
%mend test;

%test;