Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Nick Bornschein <nick.bornschein@gmail.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: reshape or something else? |
Date | Thu, 28 Nov 2013 13:15:50 +0100 |
Not exactly: the final result should look like: clear input level q1 q2 q3 2 2.05 . . 2 3.01 . . 2 0.75 . . 3 . 1.99 . 3 . 1.86 . 3 . 0.44 . 4 . . 1.21 4 . . 4.22 4 . . 2.55 end Am 28.11.13 12:55, schrieb Nick Cox:
Is this what you want? If not, show us explicitly what the reshaped data should look like. clear input value level str3 question 2.05 2 q1 3.01 2 q1 0.75 2 q1 1.99 3 q2 1.86 3 q2 0.44 3 q2 1.21 4 q3 4.22 4 q3 2.55 4 q3 end egen id = seq(), to(3) reshape wide value level, i(id) j(question) string Nick njcoxstata@gmail.com On 28 November 2013 11:39, Nick Bornschein <nick.bornschein@gmail.com> wrote:Yes, of course: clear input value level str3 question 2.05 2 q1 3.01 2 q1 0.75 2 q1 1.99 3 q2 1.86 3 q2 0.44 3 q2 1.21 4 q3 4.22 4 q3 2.55 4 q3 end So the questions should be transferred to new variable q1, q2 and so on, keeping the value and level information tne these two variables. -Nick Am 28.11.13 12:11, schrieb Nick Cox:Please show us an example of your data, e.g. the first 10 observations. Nick njcoxstata@gmail.com On 28 November 2013 09:57, Nick Bornschein <nick.bornschein@gmail.com> wrote:Hello Stata user, I have a dataset with 3 variables: "value" with numeric numbers, "level" with numeric levels from 1 to 10 and "question" with the short text of the questions (q1, q2...). Now I want to bring all the questions in seperate columns with the "value" they have in the variable "value" coressponding to the level. Using reshape I always get error messages in some way, so hope there is an easy answer. Best Nick * * 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/* * 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/
* * 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/