for Task 1, Z. format works to add leading 0s For task 2, can you please add more details? ... View more

with simple steps; data in ; input x y; ord=_n_; cards; 1 . 2 . 3 7 4 6 5 7 6 . 7 0 ; run; data y; set in (keep=y where=(y^=.)); ord=_n_; run; data  out; merge in (drop=y) y; by ord; drop ord; run; ... View more

use 'comm' variable as commAug ,commJun in any in the data. you can not keep two variables on the same name. Else use proc report proc sql; select emp_aug13.*,emp_Jun13.*   from emp_aug13,emp_Jun13   where emp_aug13.depnto=emp_Jun13.depnto; quit; deptno  commAug commJun   10     1000                 500   20     3000                 190   30     1500                  250 ... View more