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 |
Eric Booth <eric.a.booth@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: store tabulate command results in excel |

Date |
Mon, 12 Mar 2012 16:54:32 -0500 |

<> 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/

**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>

- Prev by Date:
**Re: st: store tabulate command results in excel** - Next by Date:
**Re: st: store tabulate command results in excel** - Previous by thread:
**Re: st: store tabulate command results in excel** - Next by thread:
**Re: st: store tabulate command results in excel** - Index(es):