Re: st: reshape or something else?

[Nick Bornschein <nick.bornschein@gmail.com>]

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/