step1. You may save all the formats in a single sas program at your permanent library. step2. Next you can retrieve formats using %include macro as below: %let path=file-path; libname xyz "&path"; %include 'file-path\allformats.sas'; run; proc print data=xyz.abc; format gender $gender. salary $sal.; run;
... View more
Hi, Suppose you got this dataset and want to combine two columns : data ddd; input ID var1 $ var2 $; cards; 1 a . 2 . b 3 . c 4 d . 5 e . ; run; proc sql; select coalesce(var1,var2) as combine_var from ddd; quit;
... View more