Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Data management


From   Nick Cox <njcoxstata@gmail.com>
To   statalist@hsphsun2.harvard.edu
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
<s.m.chaudhry@bham.ac.uk> 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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index