proc sql noprint; delete from have where prxmatch('/0[01]$/', Date); quit; or data want; set have; if prxmatch('/0[01]$/', Date) > 0 then delete; run;
... View more
Change the variable order method(a Dummy Format application). original order: a e f h z t x1 x2 x3 x4 x5 w new order: a e f h z t w x1 x2 x3 x4 x5 data want; format a e f h z t w x1 x2 x3 x4 x5; set have; run; * or ; data want; format a e f h z t w; set have; run;
... View more