Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: Data management
From
Nick Cox <[email protected]>
To
[email protected]
Subject
Re: st: Data management
Date
Wed, 6 Mar 2013 10:44:19 +0000
On this information, my guess is that you need to write your own
program using -write-. Perhaps you should go upstream and query why
the data are provided in this form and whether there is something more
civilised as an alternative form.
Nick
On Wed, Mar 6, 2013 at 7:37 AM, Sajid Mukhtar Chaudhry
<[email protected]> wrote:
> Hi all,
> Could anyone please answer my question regarding data management. It is about looping a variable which exists in a column and I want to put them in rows, for example I have the data in the following format:
>
> 1. bank
> 2. id
> 3. 367
> 4. lead
> 5. bank:
> 6. Bank
> 7. of
> 8. America,
> 9. Citibank
> 10. N.A.,
> 11. Bookrunner:
> 12. Barclays
> 13. bank
> 14. plc,
>
> The numbers show rows and the whole data is in one column. I want to put them in different columns like:
>
> 1. id Lead bank1 Lead bank2 Bookrunner
> 2. 367 Bank of America Citibank N.A. Barclays bank plc
>
*
* 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/