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]

st: Data editor


From   "Marie Bérégovoy" <marieberegovoy@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: Data editor
Date   Mon, 21 Jan 2013 12:03:18 -0500

I'm having problem with splitting a variable. 
I am using stata 11 for mac. 

The substantive problem is this : I have excel sheet with 13 000 events. In a column I have a variable representing the name of companies involved in this event. My problem is that there are multiples companies involved in ONE event. 

I want to split the variable to have an event for each company. Saying that for example event 1 involves company A, company B and Company C (all in the same cell) i want to have : first row and first column : event 1 ; first row and second column : company A ; second row and first column : event 1 ; second row and second column : company B ; etc. 

My data looks like this 
event_date            VC_Name 
---------------------------------------
2013/02/05            Company A 
                                 Company B
                                 Company C
2013/02/06            Company D 
                                 Company E
                                 Company F
2013/02/09            Company G 
                                 Company H
                                 Company I

I need date looks like 
event_date            VC_Name 
---------------------------------------
2013/02/05            Company A 
2013/02/05            Company B
2013/02/05            Company C
2013/02/06            Company D 
2013/02/06            Company E
2013/02/06            Company F
2013/02/09            Company G 
2013/02/09            Company H
2013/02/09            Company I

Is there a way to split the cell as I described above ? I think there might be a "automatically wrapped" function in the company cell (the character is OA in SAS). I have a lot of datas so it would be really useful. 

Thanks for your time. 

Marie Beregovoy 
*
*   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