%MACRO util_RESULTS();
%let EDERV= RAND.ABCD
%let Var=input(ABCD,$20.);
%let Var2=%SYSFUNC(SCAn(&EDERV.,4,'.|'));
%put &EDERV. &VAR1. &var. &VAR2.;
/*: ABCD is the Numeric variable with character values, EFGCH is character variable with character values, but both of them are populated with Numeric values in backend
which is not know in front end,Now i want to give the front value or backend value to derive a new variable on condition stated as below;
Log ERROR: The INPUT function referenced in the %SYSFUNC or %QSYSFUNC macro function is not found....?
how to resolve this issue..! */
data TWO;
set RAND;
ATTRIB &ENAME. Label="&label." Length=&length.;
If & Var. = "ABNORMAL" and &Var2. ne '' then NEW = &Var2.;
else If & Var. = "ABNORMAL" and &Var2. eq '' then NEW = "ABNORMAL";
else if & Var. in ('NOT DONE' , 'ND') then &ENAME. ='';
else NEW = & Var.;
run;
%MEND util_RESULTS;