@RW9, I appreciate your help. the reason is, to start with I wouldn't know if the dataset will have variable a or b, f.ex I should be able to handle following two scenarions as well, apart from ex1,ex2,ex3 in your test data. (at the end I will export all datasets to csv, so end user will have ex1,ex2,ex3, ex4,another_ex, with corrected values in a,b for ex1,ex2,ex3,another_ex note: ex4 doesnot have variable a or b. data ex4; c=1000; output; run; data another_ex; a=1000; z='xyz'; output; run;
... View more