https://communities.sas.com/t5/SAS-Programming/How-to-patch-quot-0-quot-s-ahead-a-string/m-p/794855#M254893 Start with the dataset below data _temp; input tick $; datalines; 12 1234 654321 ; run;quit; Mon, 07 Feb 2022 18:56:07 GMT hellohere 2022-02-07T18:56:07Z https://communities.sas.com/t5/SAS-Programming/How-to-patch-quot-0-quot-s-ahead-a-string/m-p/794854#M254892 <P>Say I have dataset below(x is 0-9 digit).</P> <P>xx</P> <P>xxx</P> <P>xxxxxx</P> <P>need patch "0"s ahead of them to make them like[length=6; patch 0s ahead if number of digits are less than 6]</P> <P>0000xx</P> <P>000xxx</P> <P>xxxxxx</P> <P>How to do it? Anyone?</P> Mon, 07 Feb 2022 18:53:15 GMT https://communities.sas.com/t5/SAS-Programming/How-to-patch-quot-0-quot-s-ahead-a-string/m-p/794854#M254892 hellohere 2022-02-07T18:53:15Z https://communities.sas.com/t5/SAS-Programming/How-to-patch-quot-0-quot-s-ahead-a-string/m-p/794855#M254893 Start with the dataset below data _temp; input tick $; datalines; 12 1234 654321 ; run;quit; Mon, 07 Feb 2022 18:56:07 GMT https://communities.sas.com/t5/SAS-Programming/How-to-patch-quot-0-quot-s-ahead-a-string/m-p/794855#M254893 hellohere 2022-02-07T18:56:07Z https://communities.sas.com/t5/SAS-Programming/How-to-patch-quot-0-quot-s-ahead-a-string/m-p/794857#M254895 <PRE><CODE class=" language-sas"> data have; input var1 $6.; cards; xx xxx xxxxxx ; data want; set have; need=translate(right(var1),'0',' '); run; </CODE></PRE> Mon, 07 Feb 2022 19:02:31 GMT https://communities.sas.com/t5/SAS-Programming/How-to-patch-quot-0-quot-s-ahead-a-string/m-p/794857#M254895 novinosrin 2022-02-07T19:02:31Z https://communities.sas.com/t5/SAS-Programming/How-to-patch-quot-0-quot-s-ahead-a-string/m-p/794860#M254896 Thanks a lot! Mon, 07 Feb 2022 19:09:28 GMT https://communities.sas.com/t5/SAS-Programming/How-to-patch-quot-0-quot-s-ahead-a-string/m-p/794860#M254896 hellohere 2022-02-07T19:09:28Z