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 01:16:59 +0100 |

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:*Anisa Shyti <anisa.shyti@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>

- Prev by Date:
**re: Re: st: RE: if, in using issues with ado files: syntax bug?** - Next by Date:
**Re: st: RE: if, in using issues with ado files: syntax bug?** - Previous by thread:
**Re: st: store tabulate command results in excel** - Next by thread:
**Re: st: store tabulate command results in excel** - Index(es):