Thanks for your answer. I figured it out just now and it works for my assignment. Here is the code: data time; set Slice; OrderTimeNewPart1=substrn(OrderTime,1,2); OrderTimeNewPart2=substrn(OrderTime,4,2); OrderTimeNewPart=trim(OrderTimeNewPart1)||OrderTimeNewPart2; OrderTimeNew=prxchange('s/^0+//o',-1,OrderTimeNewPart); drop OrderTimeNewPart1 OrderTimeNewPart2 OrderTimeNewPart; run;
... View more