I have a excel file in which i have a column as policy no in this way- polnr 786543,0786543 957432,00957432 0746352,746352 937526,000937526 X04578,0X04578 I want to add a condition in my code which will make 4 combinations of each policy no such as with no zero,with 1 leading zero,with 2 leading zero and 3 leading zero.no matter what combinations it has i just want this 4 combinations. i made a below code but it isnt working for these.just for the ref here it is data ds2; length pol $100; set ds; if (anydigit(pol)<1) then output; else do; do while(char(pol,1)='0'); pol=substrn(pol,2); end; output; pol="0"||strip(pol); output; pol="0"||strip(pol); output; pol="0"||strip(pol); output; end; run; please help me. Regards:)
... View more