Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: store tabulate command results in excel
From
Anisa Shyti <[email protected]>
To
[email protected]
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/