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

From |
Arina Viseth <arina@UDel.Edu> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: AW: st: AW: stack question? |

Date |
Sun, 15 Feb 2009 16:47:32 -0500 (EST) |

Sorry about it. I will make sure to check the FAQ. Thanks! Arina ---- Original message ---- >Date: Sun, 15 Feb 2009 22:33:23 +0100 >From: owner-statalist@hsphsun2.harvard.edu (on behalf of "Martin Weiss" <martin.weiss1@gmx.de>) >Subject: AW: st: AW: stack question? >To: <statalist@hsphsun2.harvard.edu> > > ><> >This has come up before >http://www.stata.com/statalist/archive/2002-09/msg00592.html >Be sure to check out the FAQ http://www.stata.com/support/faqs/, in >particular http://www.stata.com/support/faqs/data/reshape3.html > > > >HTH >Martin > > >-----Ursprüngliche Nachricht----- >Von: owner-statalist@hsphsun2.harvard.edu >[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Arina Viseth >Gesendet: Sonntag, 15. Februar 2009 22:29 >An: statalist@hsphsun2.harvard.edu >Betreff: Re: st: AW: stack question? > >I looked at reshape, but for for some years, the data is not available, and >also for some indicator, some data is not available too. Unless this does >not matter? > >Arina >---- Original message ---- >>Date: Sun, 15 Feb 2009 22:23:57 +0100 >>From: owner-statalist@hsphsun2.harvard.edu (on behalf of "Martin Weiss" ><martin.weiss1@gmx.de>) >>Subject: st: AW: stack question? >>To: <statalist@hsphsun2.harvard.edu> >> >><> >> >> >> >>************* >>help reshape >>************* >> >> >> >>HTH >>Martin >> >>-----Ursprüngliche Nachricht----- >>Von: owner-statalist@hsphsun2.harvard.edu >>[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Arina Viseth >>Gesendet: Sonntag, 15. Februar 2009 22:15 >>An: statalist@hsphsun2.harvard.edu >>Betreff: st: stack question? >> >>Dear Statalist, >> >>Thank you very much for all of your suggestions on my encode question, I >>really appreciated your kind help - my variables have been back into >>numerical thanks to you. >> >>I have another question and I was hoping you could help me on that too: I >>would like to stack some variables in my dataset but at the same time keep >>the rest of my variables - I am trying to code a loop for that but I can't >>seem to get it right. >> >>I.e., currently, my dataset currently looks like the following (I have >about >>100 indices for 15 years and 200 countries): >> >>Indice Year CountryA CountryB CountryC >>1 1995 .2 .a .1 >>1 1996 .36 .12 .45 >>2 1997 .15 .26 .45 >>2 1999 .22 .33 .11 >>3 1995 .a .22 .33 >> >>My question is how could I stack my country variables under one column >named >>"Country" by indice and year, and also have another column that would >>contain my values? >> >>so I would have the following: >> >>Indice Year Country Values >>1 1995 countryA .2 >>' 1995 countryB .a >>' ' countryC .1 >>' 1996 countryA >>' countryB >> countryC >>2 1997 countryA .15 >>' 1997 countryB .26 >>' >>3 1995 countryA .a >> 1995 countryB .22 >> 1995 countryC .33 >> >>Thank you very much in advance for any suggestion, I would immensely >>appreciate your help again. >> >>Arina >> >> >> >> >>---- Original message ---- >>>Date: Mon, 9 Feb 2009 11:05:13 -0500 >>>From: "Steichen, Thomas J." <SteichT@RJRT.com> >>>Subject: RE: st: RE: data reorganization >>>To: "'Arina Viseth'" <arina@UDel.Edu> >>> >>> It's just another layer deeper... >>> >>> qui gen newcountry = "" >>> qui gen newindice = . >>> qui gen newyear = "" >>> local j = 1 >>> levelsof country, l(c) >>> foreach co of local c { >>> levelsof indice if country == "`co'", l(i) >>> foreach index of local i { >>> levelsof year if indice == `index' & country == >>> "`co'", l(yrs) s(", ") >>> qui replace newcountry = "`co'" in `j' >>> qui replace newindice = `index' in `j' >>> qui replace newyear = "`yrs'" in `j' >>> local j = `j' + 1 >>> } >>> } >>> ----------------------------------- >>> Thomas J. Steichen >>> steicht@rjrt.com >>> ----------------------------------- >>> >>> -----Original Message----- >>> From: Arina Viseth [mailto:arina@UDel.Edu] >>> Sent: Monday, February 09, 2009 10:42 AM >>> To: Steichen, Thomas J. >>> Subject: Re: st: RE: data reorganization >>> >>> Dear Mr. Steichen, >>> >>> I was wondering if you could please help me one more >>> time. I would really appreciate your help once more. >>> I have another column "Country", and I would like to >>> do the exact same thing for each country. >>> >>> i.e. instead of having >>> >>> Country Indice Year >>> A 1 1990 >>> A 1 1991 >>> B 2 1993 >>> B 3 1996 >>> B 3 1997 >>> C 1 1990 >>> >>> it would be: >>> Country Indice Year >>> A 1 1990,1991 >>> B 2 1993 >>> B 3 1996, 1997 >>> C 1 1990 >>> >>> I am very grateful for your precious help yesterday. >>> Thank you very much in advance for your time. >>> >>> Arina >>> >>> ---- Original message ---- >>> >Date: Sat, 7 Feb 2009 18:44:26 -0500 >>> >From: owner-statalist@hsphsun2.harvard.edu (on >>> behalf of "Steichen, Thomas J." <SteichT@RJRT.com>) >>> >Subject: st: RE: data reorganization >>> >To: "'statalist@hsphsun2.harvard.edu'" >>> <statalist@hsphsun2.harvard.edu> >>> > >>> >I can't imagine a reason for wanting this but the >>> following code will do so (but in new variables). >>> > >>> >levelsof indice, l(i) >>> >qui gen newindice = . >>> >qui gen newyear = "" >>> >local j = 1 >>> >foreach index of local i { >>> > levelsof year if indice == `index', l(yrs) s(", >>> ") >>> > qui replace newindice = `index' in `j' >>> > qui replace newyear = "`yrs'" in `j' >>> > local j = `j' + 1 >>> >} >>> > >>> >----------------------------------- >>> >Thomas J. Steichen >>> >steicht@rjrt.com >>> >----------------------------------- >>> > >>> >-----Original Message----- >>> >From: owner-statalist@hsphsun2.harvard.edu >>> [mailto:owner-statalist@hsphsun2.harvard.edu] On >>> Behalf Of Arina Viseth >>> >Sent: Saturday, February 07, 2009 6:08 PM >>> >To: statalist@hsphsun2.harvard.edu >>> >Subject: st: data reorganization >>> > >>> >Dear all, >>> > >>> >I have a question regarding how to re-organize my >>> data on stata. >>> > >>> >Here is how the data currently looks: >>> > >>> >Indice Year >>> >1 1990 >>> >1 1991 >>> >2 2000 >>> >2 2001 >>> >2 2003 >>> >3 1995 >>> >3 1996 >>> >4 2002 >>> > >>> >Would it be possible to re-arrange the data so that >>> I would have the following: >>> > >>> >Indice Year >>> >1 1990, 1991 >>> >2 2000, 2001, 2003 >>> >3 1995, 1996 >>> >4 2002 >>> > >>> > >>> >Any suggestion would be very much appreciated. >>> Thank you in advance. >>> > >>> >Arina >>> > >>> >* >>> >* For searches and help try: >>> >* http://www.stata.com/help.cgi?search >>> >* http://www.stata.com/support/statalist/faq >>> >* http://www.ats.ucla.edu/stat/stata/ >>> > >>> >CONFIDENTIALITY NOTE: This e-mail message, >>> including any attachment(s), contains information >>> that may be confidential, protected by the >>> attorney-client or other legal privileges, and/or >>> proprietary non-public information. If you are not >>> an intended recipient of this message or an >>> authorized assistant to an intended recipient, >>> please notify the sender by replying to this message >>> and then delete it from your system. Use, >>> dissemination, distribution, or reproduction of this >>> message and/or any of its attachments (if any) by >>> unintended recipients is not authorized and may be >>> unlawful. >>> > >>> >* >>> >* For searches and help try: >>> >* http://www.stata.com/help.cgi?search >>> >* http://www.stata.com/support/statalist/faq >>> >* http://www.ats.ucla.edu/stat/stata/ >>> >>> ------------------------------------------------ >>> >>> CONFIDENTIALITY NOTE: This e-mail message, including >>> any attachment(s), contains information that may be >>> confidential, protected by the attorney-client or >>> other legal privileges, and/or proprietary >>> non-public information. If you are not an intended >>> recipient of this message or an authorized assistant >>> to an intended recipient, please notify the sender >>> by replying to this message and then delete it from >>> your system. Use, dissemination, distribution, or >>> reproduction of this message and/or any of its >>> attachments (if any) by unintended recipients is not >>> authorized and may be unlawful. >>* >>* For searches and help try: >>* http://www.stata.com/help.cgi?search >>* http://www.stata.com/support/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/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/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/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/statalist/faq * http://www.ats.ucla.edu/stat/stata/

**References**:**st: data reorganization***From:*Arina Viseth <arina@UDel.Edu>

**st: RE: data reorganization***From:*"Steichen, Thomas J." <SteichT@RJRT.com>

**st: stack question?***From:*Arina Viseth <arina@UDel.Edu>

**st: AW: stack question?***From:*"Martin Weiss" <martin.weiss1@gmx.de>

**Re: st: AW: stack question?***From:*Arina Viseth <arina@UDel.Edu>

**AW: st: AW: stack question?***From:*"Martin Weiss" <martin.weiss1@gmx.de>

- Prev by Date:
**AW: st: AW: stack question?** - Next by Date:
**Re: st: Re: ice command question about interactions** - Previous by thread:
**AW: st: AW: stack question?** - Next by thread:
**st: How to detect the change of i over t?** - Index(es):

© Copyright 1996–2014 StataCorp LP | Terms of use | Privacy | Contact us | What's new | Site index |