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 editor


From   William Buchanan <william@williambuchanan.net>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   Re: st: Data editor
Date   Mon, 21 Jan 2013 09:09:05 -0800

Save the file to .csv format and import it to Stata that way.  There are some specific resources to address exactly this problem on the Stata FAQ site.  You should be able to use that information easily to accomplish filling in the missing values that you are dealing with. 

Sent from my iPhone

On Jan 21, 2013, at 9:03, "Marie Bérégovoy" <marieberegovoy@gmail.com> wrote:

> 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/

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