Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Michael Stewart <michaelstewartresearch@gmail.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: SV: leading zeros in string format |
Date | Fri, 8 Feb 2013 15:01:01 -0500 |
HI Rebecca and Petter, gen newstring = string(real(oldvar),"%07.0f")==>works Thanks a lot Mike On Fri, Feb 8, 2013 at 2:51 PM, Rebecca Pope <rebecca.a.pope@gmail.com> wrote: > That's because you're starting with a string... Petter's code works > fine with one modification: > > gen newstring = string(real(oldvar),"%07.0f") > > > > On Fri, Feb 8, 2013 at 1:45 PM, Michael Stewart > <michaelstewartresearch@gmail.com> wrote: >> I have tried it and get >> >> type mismatch >> r(109); >> >> >> On Fri, Feb 8, 2013 at 2:41 PM, Petter Berg <pbe@copenhageneconomics.com> wrote: >>> Mike if you have a fixed string length (in this case of 7) and just want to fill up with zeros you can use: >>> gen newstring = string(oldvar,"%07.0f") >>> >>> Best, >>> Petter >>> ________________________________________ >>> Från: owner-statalist@hsphsun2.harvard.edu [owner-statalist@hsphsun2.harvard.edu] för Michael Stewart [michaelstewartresearch@gmail.com] >>> Skickat: den 8 februari 2013 20:24 >>> Till: statalist@hsphsun2.harvard.edu >>> Ämne: st: leading zeros in string format >>> >>> HI >>> I am trying to convert a string variable to a string variable with >>> fixed numbers >>> >>> My string variable has following observations: >>> 1223435 >>> 34567 >>> 345 >>> >>> I want to convert it to another string variable with leading zeros >>> 1223435 >>> 0034567 >>> 0000345 >>> >>> format var "%07.0f" didnt work >>> >>> Thank you , >>> Yours Sincerely, >>> Mike. >>> * >>> * For searches and help try: >>> * http://www.stata.com/help.cgi?search >>> * http://www.stata.com/support/faqs/resources/statalist-faq/ >>> * http://www.ats.ucla.edu/stat/stata/ >>> >>> * >>> * For searches and help try: >>> * http://www.stata.com/help.cgi?search >>> * http://www.stata.com/support/faqs/resources/statalist-faq/ >>> * http://www.ats.ucla.edu/stat/stata/ >> >> >> >> -- >> Thank you , >> Yours Sincerely, >> Mike. >> >> * >> * For searches and help try: >> * http://www.stata.com/help.cgi?search >> * http://www.stata.com/support/faqs/resources/statalist-faq/ >> * http://www.ats.ucla.edu/stat/stata/ > > * > * For searches and help try: > * http://www.stata.com/help.cgi?search > * http://www.stata.com/support/faqs/resources/statalist-faq/ > * http://www.ats.ucla.edu/stat/stata/ -- Thank you , Yours Sincerely, Mike. * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/