Hello,
I don't really understand what the last datastep is for so i ignored it.
%let table_name=sashelp.class;
data oper_flt;
infile cards dlm=',' dsd;
length table_name $32 col_nm $32 operant $2;
input flt_id table_name col_nm operant value;
cards;
1,sashelp.class,age,=,12
1,sashelp.class,weight,ge,90
;
run;
data _NULL_;
call execute('proc sql noprint; CREATE TABLE want AS SELECT * FROM &table_name. WHERE ');
do until(fend);
set oper_flt (where=(table_name="&table_name.")) end=fend;
call execute(catx(' ', col_nm, operant, value, 'OR'));
end;
call execute('0; quit;');
stop;
run;
... View more
