Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


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

Re: st: store tabulate command results in excel


From   Anisa Shyti <anisa.shyti@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: store tabulate command results in excel
Date   Tue, 13 Mar 2012 17:34:12 +0100

Hi Eric,

Apologies for the variable mismatch - feedback and condition are the
same - that's accurate.  Below you find the exact structure of my
data.  I have the row as an existing variable already, since questions
have subquestions (in rows):

user_id questionid      row     Answer  Condition
1       1       1       A       - feedback 1
1       1       2       A       - feedback 1
1       1       3       A       - feedback 1
1       1       4       B       - feedback 1
1       1       5       B       - feedback 1
1       1       6       B       - feedback 1
1       1       7       B       - feedback 1
1       1       8       B       - feedback 1
1       1       9       B       - feedback 1
1       1       10      B       - feedback 1
1       1       11      B       - feedback 1
2       1       1       A       - feedback 1
2       1       2       A       - feedback 1
2       1       3       A       - feedback 1
2       1       4       A       - feedback 1
2       1       5       A       - feedback 1
2       1       6       A       - feedback 1
2       1       7       A       - feedback 1
2       1       8       A       - feedback 1
2       1       9       A       - feedback 1
2       1       10      A       - feedback 1
2       1       11      A       - feedback 1
2       2       1       A       - feedback 1
2       2       2       A       - feedback 1
2       2       3       A       - feedback 1
2       2       4       A       - feedback 1
2       2       5       A       - feedback 1
2       2       6       A       - feedback 1
2       2       7       A       - feedback 1
2       2       8       A       - feedback 1
2       2       9       A       - feedback 1
2       2       10      A       - feedback 1
2       2       11      A       - feedback 1
2       2       12      A       - feedback 1
2       2       13      A       - feedback 1
2       2       14      A       - feedback 1
2       2       15      A       - feedback 1
2       2       16      A       - feedback 1
2       2       17      A       - feedback 1
2       2       18      A       - feedback 1
2       2       19      A       - feedback 1
2       2       20      A       - feedback 1
2       2       21      A       - feedback 1
2       2       22      A       - feedback 1
2       2       23      A       - feedback 1
2       2       24      A       - feedback 1
2       2       25      A       - feedback 1
2       2       26      A       - feedback 1
12      1       1       B       - feedback 2
12      1       2       B       - feedback 2
12      1       3       B       - feedback 2
12      1       4       B       - feedback 2
12      1       5       B       - feedback 2
12      1       6       B       - feedback 2
12      1       7       B       - feedback 2
12      1       8       B       - feedback 2
12      1       9       B       - feedback 2
12      1       10      B       - feedback 2
12      1       11      B       - feedback 2
12      2       1       B       - feedback 2
12      2       2       B       - feedback 2
12      2       3       B       - feedback 2
12      2       4       B       - feedback 2
12      2       5       B       - feedback 2
12      2       6       B       - feedback 2
12      2       7       B       - feedback 2
12      2       8       B       - feedback 2
12      2       9       B       - feedback 2
12      2       10      B       - feedback 2
12      2       11      B       - feedback 2
12      2       12      B       - feedback 2
12      2       13      B       - feedback 2
12      2       14      B       - feedback 2
12      2       15      B       - feedback 2
12      2       16      B       - feedback 2
12      2       17      B       - feedback 2
12      2       18      B       - feedback 2
12      2       19      B       - feedback 2
12      2       20      B       - feedback 2
12      2       21      B       - feedback 2
12      2       22      B       - feedback 2
12      2       23      B       - feedback 2
12      2       24      B       - feedback 2
12      2       25      B       - feedback 2
12      2       26      A       - feedback 2
14      12      1       A       - feedback 2
14      12      2       A       - feedback 2
14      12      3       A       - feedback 2
14      12      4       A       - feedback 2
14      12      5       A       - feedback 2
14      12      6       A       - feedback 2
14      12      7       A       - feedback 2
14      12      8       A       - feedback 2
14      12      9       A       - feedback 2
14      12      10      A       - feedback 2
14      12      11      A       - feedback 2
14      12      12      A       - feedback 2
14      12      13      A       - feedback 2
14      12      14      B       - feedback 2
14      12      15      B       - feedback 2
14      12      16      B       - feedback 2
14      12      17      B       - feedback 2
14      12      18      B       - feedback 2
14      12      19      B       - feedback 2
14      12      20      B       - feedback 2
14      12      21      B       - feedback 2
14      12      22      B       - feedback 2
14      12      23      B       - feedback 2
14      12      24      B       - feedback 2
14      12      25      B       - feedback 2
14      12      26      B       - feedback 2


I need a nested structure of the tab to refine the analysis, to see
for each row the % A and B and the evolution on answers according to
Condition.

The structure of the output needs to be something like:

QuestionID i
...........................row1........row2.........row3........row4........................rowN
Feedback 1........ nr (%)A.....nr(%)A.....nr(%)A......nr(%)A................
Feedback 2........ nr (%)A.....nr(%)A.....nr(%)A......nr(%)A................
Feedback 3........ nr (%)A.....nr(%)A.....nr(%)A......nr(%)A................

It's like zooming in in each of the previous cells (instead of having
the total nr and % of A/B answers).

Is this more clear?

I tried what you suggest, but it generates Condition+row without
keeping the distinction by user and questionID.  How can I compose
Condtion+Row given the structure of my data, preserving the rest of
the information?

Thank a lot.
*
*   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/


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