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 on April 23, 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 14:57:51 +0100

Hi Eric,

One more detail on this same issue addressed above.

If I want to refine the analysis even more, and add one more level of
analysis as follows - Row - is the additional detail:

QuestionID.......Condition......Row.......Answer
1..........................1...............1............Y
1..........................1...............2............Y
1..........................1...............3............N
1..........................1...............4............N
1..........................1...............5............N
1..........................2...............1............Y
1..........................2...............2............N
1..........................2...............3............N
1..........................2...............4............N

I would like to have the precise detail of number and  % of Y answers
given the QuestionID and Feedback.

I tried to modify the code as follows:

******************************************************

cap rm "testQIDrow.xls"
levelsof questionid, loc(q)
foreach n in `q' {
 tabout feedback row choice ///
    if questionid == `n'   ///
  using "testQIDrow.xls", append  ///
    c(freq row) h1(Question `n' )
       }
	

	
levelsof feedback, loc(c)
foreach v in `c' {
       loc j `" `j' `v' "- feedback `v'" "'
       }

lab def jj `j', modify
lab val feedback jj
ta feedback

levelsof row, loc(d)
foreach r in `d' {
loc i `" `i' `r' '
}
lab def ii `i', modify
lab val row ii
ta row

******************************************************************

This code does return a tabulation for Row, but not per each category
of feedback.

How shall the code be modify to suit Row nested into feedback?  Hope I
am clear enough.

Thanks a lot.
Anisa




On Tue, Mar 13, 2012 at 1:16 AM, Anisa Shyti <anisa.shyti@gmail.com> wrote:
> Thanks Eric!
>
> Problem solved - works wonderfully!!!!
>
> Thanks a lot,
> Cheers
> Anisa
>
> On Mon, Mar 12, 2012 at 10:57 PM, Eric Booth <eric.a.booth@gmail.com> wrote:
>> <>
>>
>> BTW, if you wanted to add the labels to "Condition" in the -tabout- table as you do in your example, then add this code into your do-file just before you run the loop I gave you:
>>
>> ************ add in to prev. code example
>> levelsof Condition, loc(c)
>> foreach v in `c' {
>>        loc j `" `j' `v' "- Condition `v'" "'
>>        }
>>
>> lab def jj `j', modify
>> lab val Condition jj
>> ta Condition
>> ************
>>
>> - Eric
>>
>> __
>> Eric A. Booth
>> Public Policy Research Institute
>> Texas A&M University
>> ebooth@ppri.tamu.edu
>> +979.845.6754
>>
>> On Mar 12, 2012, at 4:54 PM, Eric Booth wrote:
>>
>>>
>>>
>>> <>
>>>
>>> The answer is basically the same then (save a correction in my previous email noted below).
>>>
>>> So, you could run:
>>>
>>> ****************
>>> clear
>>>
>>> input QuestionID   Condition str2  Answer
>>> 1     1         Y
>>> 1     1         N
>>> 1     1         N
>>> 1     2         Y
>>> 1     2         Y
>>> 1     2         N
>>> 2     1         Y
>>> 2     1         Y
>>> 2     1         N
>>> 2     2         Y
>>> 2     2         N
>>> 2     2         N
>>> end
>>>
>>>
>>> ******
>>> cap rm "test.xls"
>>> levelsof QuestionID, loc(q)
>>> foreach n in `q' {
>>>  tabout Condition Answer ///
>>>     if QuestionID == `n' /* I left this part out in the previous answ.*/  ///
>>>   using "test.xls", append  ///
>>>     c(freq row) h1(Question `n' )
>>>        }
>>> ****************
>>>
>>> - Eric
>>>
>>> __
>>> Eric A. Booth
>>> Public Policy Research Institute
>>> Texas A&M University
>>> ebooth@ppri.tamu.edu
>>> +979.845.6754
>>>
>>> On Mar 12, 2012, at 4:38 PM, Anisa Shyti wrote:
>>>
>>>> Hi Eric,
>>>>
>>>> Thanks for the answer.
>>>>
>>>> Condition is actually a categorical variable coded as (1, 2, 3).
>>>> Answer is string and there are 12 questions - questionIDs are
>>>> integers.  My data structure is the following:
>>>>
>>>> QuestionID..............Condition................Answer
>>>> 1..............................1.............................Y
>>>> 1..............................1.............................N
>>>> 1..............................1.............................N
>>>> 1..............................2.............................Y
>>>> 1..............................2.............................Y
>>>> 1..............................2.............................N
>>>> 2..............................1.............................Y
>>>> 2..............................1.............................Y
>>>> 2..............................1.............................N
>>>> 2..............................2.............................Y
>>>> 2..............................2.............................N
>>>> 2..............................2.............................N
>>>>
>>>>
>>>> My table should look like:
>>>>
>>>> .................................Answer...........................
>>>> ................................Y..................N..........Total
>>>> Question1................
>>>> -Condition1..............nr(%).............nr(%).....nr(%)
>>>> -Condition2..............nr(%).............nr(%).....nr(%)
>>>> Question2
>>>> -Condition1..............nr(%).............nr(%).....nr(%)
>>>> -Condition2..............nr(%).............nr(%).....nr(%)
>>>>
>>>> Thank you very much in advance.
>>>> Anisa
>>>>
>>>>
>>>>
>>>>
>>>> On Mon, Mar 12, 2012 at 10:21 PM, Eric Booth <eric.a.booth@gmail.com> wrote:
>>>>> <>
>>>>>
>>>>> I don't understand your data structure (e.g. what are conditions?) and why -tabout- (from SSC, BTW) does not work.  Providing a snippet of your dataset and the command you tried would help me provide a better answer.
>>>>>
>>>>>
>>>>> Based just on your sample -tab- command, you can transform that to -tabout- with something like:
>>>>>
>>>>>
>>>>> ******
>>>>> cap rm "test.xls"
>>>>> levelsof question, local(ques_numbers)
>>>>> foreach n in `ques_numbers' {
>>>>>  tabout condition answer using "test.xls", append  ///
>>>>>     c(freq row) h1(Question `n' )
>>>>>        }
>>>>> ******
>>>>> ((The looping part is doing the -bysort question- part of your example -tab- command.))
>>>>>
>>>>> - Eric
>>>>>
>>>>> __
>>>>> Eric A. Booth
>>>>> Public Policy Research Institute
>>>>> Texas A&M University
>>>>> ebooth@ppri.tamu.edu
>>>>> +979.845.6754
>>>>>
>>>>> On Mar 12, 2012, at 4:07 PM, Anisa Shyti wrote:
>>>>>
>>>>>
>>>>>> I need to store in excel or any other support the results of a two-way
>>>>>> tabulate command.  My variables are: question, condition and asnwer.
>>>>>> I have N questions, three conditions for each question, and Y or N
>>>>>> answers by subjects.
>>>>>>
>>>>>> The tab command (by question, sort: tab condition answer, row) gives
>>>>>> exactly what I need. For each question (distinguished by id) and each
>>>>>> condition, I have the number and percentage of Y and N answers and the
>>>>>> Total - in columns.
>>>>>>
>>>>>> Still, I would like to be able to store these results in excel or any
>>>>>> other support, instead of copy pasting.  I tried using the tabout
>>>>>> command (my case is a 2x1 table) - it does not give me the desired
>>>>>> format.
>>>>>> *
>>>>>> *   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/


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