Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: importing txt file changes format of variable


From   "Scott Merryman" <[email protected]>
To   [email protected]
Subject   Re: st: importing txt file changes format of variable
Date   Fri, 8 Feb 2008 21:00:54 -0600

tostring us_id, replace format(%06.0f)

Scott


On Feb 8, 2008 1:46 PM, Ms. Marilyn Ibarra <[email protected]> wrote:
>
> I have the following data in a txt file:
>
> us_id       firm
> 000007       x
> 010234       y
> 321098       z
> 112411       w
>
> When I import it into stata I get this:
>
> us_id       firm
> 7            x
> 10234        y
> 321098       z
> 112411       w
>
> Where the us_id changes in the first two observations (it changes for any observations that have a us_id with zeros at the beginning).  I need us_id to be a 6 digit id number for each firm (ncluding any zeros at the beginning).  This needs to be a string variable but is a numeric variable when imported into 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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index