Hi SASKiwi here is the code options noquotelenmax; options nomlogic mprint nosymbolgen; %macro ins(USER_RATE_ASSIGNMENT_NAME); %global cnt1; proc sql; select count(*) into :cnt1 from SASDEV.EDM_RATE_ASSIGNMENT where RATE_ASSIGNMENT_NAME="&USER_RATE_ASSIGNMENT_NAME"; %put count &cnt1; %mend ins; data STATIC.STATUS; set STATIC.Manual_correction; length STATUS $200; if not missing(USER_RATE_ASSIGNMENT_NAME) then do; if not missing(USER_RATE_ASSIGNMENT_NAME) then do; call execute('%ins(USER_RATE_ASSIGNMENT_NAME = '||USER_RATE_ASSIGNMENT_NAME||')'); count=symget('cnt1'); if count=0 then do; RAerror='Enter Valid Rate Assignment Name'; end; if count=1 then do; RAerror=' '; end; end; %put &cnt; %put count; end; run; I am trying to check the rate_assignment_name count using the macro variable cnt but it is always showing '0' in the count.
... View more