Hi! the if exists function doesn't work for view only for table how can i make it work? code snippet: %do i=&yymm.01 %to &yymm.31;
%if %sysfunc(exist(test.a&i.,'VIEW')) %then %do;
data _null_;
call symput('_tmp_act_dt_',strip(input("&i.",yymmdd6.)));
run; I always get FALSE but the view is an existing view. %DO loop beginning; index variable I; start value is 200201; stop value is 200231; by value is 1. SYMBOLGEN: Macro variable I resolves to 200201 MLOGIC(test_macro): %IF condition %sysfunc(exist(da_d2.ut&i.,'VIEW')) is FALSE MLOGIC(test_macro): %DO loop index variable I is now 200202; loop will iterate thanks
... View more