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: [email protected] (on behalf of "Martin Weiss" <[email protected]>)
>Subject: AW: st: AW: stack question?
>To: <[email protected]>
>
>
><>
>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: [email protected]
>[mailto:[email protected]] Im Auftrag von Arina Viseth
>Gesendet: Sonntag, 15. Februar 2009 22:29
>An: [email protected]
>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: [email protected] (on behalf of "Martin Weiss"
><[email protected]>)
>>Subject: st: AW: stack question?
>>To: <[email protected]>
>>
>><>
>>
>>
>>
>>*************
>>help reshape
>>*************
>>
>>
>>
>>HTH
>>Martin
>>
>>-----Ursprüngliche Nachricht-----
>>Von: [email protected]
>>[mailto:[email protected]] Im Auftrag von Arina Viseth
>>Gesendet: Sonntag, 15. Februar 2009 22:15
>>An: [email protected]
>>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." <[email protected]>
>>>Subject: RE: st: RE: data reorganization
>>>To: "'Arina Viseth'" <[email protected]>
>>>
>>> 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
>>> [email protected]
>>> -----------------------------------
>>>
>>> -----Original Message-----
>>> From: Arina Viseth [mailto:[email protected]]
>>> 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: [email protected] (on
>>> behalf of "Steichen, Thomas J." <[email protected]>)
>>> >Subject: st: RE: data reorganization
>>> >To: "'[email protected]'"
>>> <[email protected]>
>>> >
>>> >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
>>> >[email protected]
>>> >-----------------------------------
>>> >
>>> >-----Original Message-----
>>> >From: [email protected]
>>> [mailto:[email protected]] On
>>> Behalf Of Arina Viseth
>>> >Sent: Saturday, February 07, 2009 6:08 PM
>>> >To: [email protected]
>>> >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/