hello fja, thank you below is what im currently doing for 1 dataset, it works but im thinking its bad code: libname mylib "\folder path"; title "a1"; *add a title for each dataset so that the results table is clear; proc sql; select count(a) as a, count(b) as b, count(c) as c, count(d) as d, count(e) as e, count(f) as f, count(g) as g, count(h) as h, count(i) as i, count(j) as j, count(k) as k, count(l) as l, count(m) as m, count(n) as n, count(o) as o, count(p) as p from mylib.a1_cleaned; quit;
... View more