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]

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/

**Follow-Ups**:**Re: st: store tabulate command results in excel***From:*Eric Booth <eric.a.booth@gmail.com>

**References**:**st: store tabulate command results in excel***From:*Anisa Shyti <anisa.shyti@gmail.com>

**Re: st: store tabulate command results in excel***From:*Eric Booth <eric.a.booth@gmail.com>

**Re: st: store tabulate command results in excel***From:*Anisa Shyti <anisa.shyti@gmail.com>

**Re: st: store tabulate command results in excel***From:*Eric Booth <eric.a.booth@gmail.com>

**Re: st: store tabulate command results in excel***From:*Eric Booth <eric.a.booth@gmail.com>

**Re: st: store tabulate command results in excel***From:*Anisa Shyti <anisa.shyti@gmail.com>

- Prev by Date:
**re: re: RE: st: areg Vs fe** - Next by Date:
**Re: st: incidence rate** - Previous by thread:
**Re: st: store tabulate command results in excel** - Next by thread:
**Re: st: store tabulate command results in excel** - Index(es):