topic Leading 0 in SAS Programming https://communities.sas.com/t5/SAS-Programming/Leading-0/m-p/98421#M20784 <HTML><HEAD></HEAD><BODY><P>There is a column that has values mix of Alphabets and numbers. I need to append a leading 0 if there only a single digit as shown below:</P><P></P><P>ColumA</P><P>MV</P><P>ZX</P><P>5</P><P>12</P><P>The above should be:</P><P>ColumA</P><P>MV</P><P>ZX</P><P>05</P><P>12</P></BODY></HTML> Mon, 30 Sep 2013 14:31:27 GMT SASPhile 2013-09-30T14:31:27Z Leading 0 https://communities.sas.com/t5/SAS-Programming/Leading-0/m-p/98421#M20784 <HTML><HEAD></HEAD><BODY><P>There is a column that has values mix of Alphabets and numbers. I need to append a leading 0 if there only a single digit as shown below:</P><P></P><P>ColumA</P><P>MV</P><P>ZX</P><P>5</P><P>12</P><P>The above should be:</P><P>ColumA</P><P>MV</P><P>ZX</P><P>05</P><P>12</P></BODY></HTML> Mon, 30 Sep 2013 14:31:27 GMT https://communities.sas.com/t5/SAS-Programming/Leading-0/m-p/98421#M20784 SASPhile 2013-09-30T14:31:27Z Re: Leading 0 https://communities.sas.com/t5/SAS-Programming/Leading-0/m-p/98422#M20785 <HTML><HEAD></HEAD><BODY><P>This works for your presented data. If you have more complex scenario, please exhaust them in your post.</P><P>data have;</P><P>input ColumA$2.;</P><P>if length(ColumA)=1 and anydigit(ColumA)&gt;0 then ColumA=cats('0',ColumA); </P><P>cards;</P><P>MV</P><P>ZX</P><P>5</P><P>12</P><P>;</P><P></P><P>Haikuo </P></BODY></HTML> Mon, 30 Sep 2013 15:07:18 GMT https://communities.sas.com/t5/SAS-Programming/Leading-0/m-p/98422#M20785 Haikuo 2013-09-30T15:07:18Z