Bookmark and Share

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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index