***buffer*****
I completely missed that. Thanks!
> Try: format ndc %012.0f
>
> (the zero after the % is what adds leading zeros).
>
> Tom
>
> > > Actual NDC codes are (usually) of the form 12345-1234-12,
> > > i.e. 5-4-2 digits, for a total of 13 inclusive of the two dashes.
> > >
> > > So any numeric format with less than 11 digits is actually
> > > that number with leading zeros.
> > >
> > > I have read the FAQ at
> > > http://www.stata.com/support/faqs/data/leading0.html , and
> > > followed the directions, but for some reason the resulting
> > > string does not have leading zeroes.
> > >
> > > my code runs as follows:
> > > ****************************
> > > format ndc %12.0f
> > > gen str12 sndc=string(ndc, "%12.0f")
> > > gen sndclen=length(sndc)
> > > tab sndclen, missing
> > >
> > > ndclength | Freq. Percent Cum.
> > > ------------+-----------------------------------
> > > 7 | 559,577 10.42 10.42
> > > 8 | 1,843,485 34.32 44.74
> > > 9 | 1,917,644 35.70 80.44
> > > 10 | 203 0.00 80.44
> > > 11 | 1,047,475 19.50 99.94
> > > 12 | 3,260 0.06 100.00
> > > ------------+-----------------------------------
> > > Total | 5,371,644 100.00
> > > *********************************
> > >
> > > The 12-digit figures are actually missings (all 9's), so I
> > > recoded them, reverted via "real", and then re-converted with
> > > -string- again...
> > >
> > > *********
> > > replace sndc="" if sndclen==12
> > > gen ndc2=real(sndc)
> > > gen str11 sndc2=string(ndc2, "%11.0f")
> > > ***********
> > >
> > > This does not return leading zero's either.
> > >
> > > Any suggestions?
> > >
> > > TIA,
> > >
> > > Daniel Egan
> > >
> > >
> > >
> > > ****************
> > > Stata/SE 9.0 for Windows
> > > Born 05 Jul 2005
> > > Total physical memory: 2097151 KB
> > > Available physical memory: 1425028 KB
> > >
> > > Stata executable
> > > folder: C:\Program Files\Stata9\
> > > name of file: wsestata.exe
> > > currently installed: 05 Jul 2005
> > >
> > > Ado-file updates
> > > folder: C:\Program Files\Stata9\ado\updates\
> > > names of files: (various)
> > > currently installed: 05 Jul 2005
> > > ******************
> > >
> > > *
> > > * For searches and help try:
> > > * http://www.stata.com/support/faqs/res/findit.html
> > > * http://www.stata.com/support/statalist/faq
> > > * http://www.ats.ucla.edu/stat/stata/
> > >
> >
> > -----------------------------------------
> > CONFIDENTIALITY NOTE: This e-mail message, including any
> > attachment(s), contains information that may be confidential,
> > protected by the attorney- client or other legal privileges,
> > and/or proprietary non-public information. If you are not
> > an intended recipient of this message or an authorized
> > assistant to an intended recipient, please notify the sender
> > by replying to this message and then delete it from your
> > system. Use, dissemination, distribution, or reproduction
> > of this message and/or any of its attachments (if any) by
> > unintended recipients is not authorized and may be unlawful.
> >
> >
> > *
> > * For searches and help try:
> > * http://www.stata.com/support/faqs/res/findit.html
> > * http://www.stata.com/support/statalist/faq
> > * http://www.ats.ucla.edu/stat/stata/
> >
>
> -----------------------------------------
> CONFIDENTIALITY NOTE: This e-mail message, including any attachment(s),
> contains information that may be confidential, protected by the attorney-
> client or other legal privileges, and/or proprietary non-public
> information. If you are not an intended recipient of this message or an
> authorized assistant to an intended recipient, please notify the sender by
> replying to this message and then delete it from your system. Use,
> dissemination, distribution, or reproduction of this message and/or any of
> its attachments (if any) by unintended recipients is not authorized and
> may be unlawful.
>
>
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/