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 ¬pure is NOT a pure numeric, it includes some characters('aqw').how to know this?
%let notpure=123aqw4567;
%let pure=12345;
Thanks
Mike
%let notpure=123aqw4567;
%put %sysfunc(notdigit(¬pure.));
%let pure=12345;
%put %sysfunc(notdigit(&pure.));
Awesome,
Thanks Art!
Mike
Why not use the SAS supplied macro DATATYP ?
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.