[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
"Martin Weiss" <martin.weiss1@gmx.de> |

To |
<statalist@hsphsun2.harvard.edu> |

Subject |
RE: st: RE: Sorting in a table a list of binomial variables by frequency of apparition in a survey context |

Date |
Thu, 16 Oct 2008 11:40:40 +0200 |

As your dataset is identical with the list output, try this: ************ cap ssc inst parmest sysuse auto, clear prop r parmest, saving(myfile, replace) u myfile, clear drop eq parm dof t p gsort -est *l outsheet using myfile.csv, comma replace ! myfile.csv ************ HTH Martin -----Original Message----- From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Ángel Rodríguez Laso Sent: Thursday, October 16, 2008 10:11 AM To: statalist@hsphsun2.harvard.edu Subject: Re: st: RE: Sorting in a table a list of binomial variables by frequency of apparition in a survey context Thanks, Martin, it worked very well. The only problem is that the -list- output copied to Excel doesn't look nice. I've sorted it out through transferring the .dta obtained with parmest to .txt and then reading it in Excel. This takes some time. I wonder if there is a quicker way to paste the -list- output (or any other alternative command that tabulates in a similar way) into Excel. Best regards, Angel Rodriguez-Laso 2008/10/13 Martin Weiss <martin.weiss1@gmx.de>: > Why not use -proportion- which allows -pweight-s and then store the results > via -ssc d parmest-. Save it with -parmest- as .dta and -gsort -estimates- > afterwards. Then -list- and you have your table... > > Example (w/o pweights): > > ************ > cap ssc inst parmest > sysuse auto, clear > prop r > parmest, saving(myfile, replace) > u myfile, clear > drop eq parm dof t p > gsort -est > l > ************ > > > HTH > Martin > > > -----Original Message----- > From: owner-statalist@hsphsun2.harvard.edu > [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Ángel Rodríguez > Laso > Sent: Monday, October 13, 2008 12:28 PM > To: statalist@hsphsun2.harvard.edu > Subject: st: Sorting in a table a list of binomial variables by frequency of > apparition in a survey context > > Dear Statalisters, > > I have a list of binomial variables where 1 means that the individual > has a determined disease. I need a table where proportions (and their > confidence intervals) of these variables (diseases) appear in > descending order. Although tab1 has a sort option, my data belong to a > survey where pweights are used, and tab1 only accepts fweights (that > need to be integers, which is not the case). > > Any alternative? > > Many thanks. > > Angel Rodriguez-Laso > * > * 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/

**References**:**st: Sorting in a table a list of binomial variables by frequency of apparition in a survey context***From:*"Ángel Rodríguez Laso" <angelrlaso@gmail.com>

**Re: st: RE: Sorting in a table a list of binomial variables by frequency of apparition in a survey context***From:*"Ángel Rodríguez Laso" <angelrlaso@gmail.com>

- Prev by Date:
**st: RE: xtpmg: saved results** - Next by Date:
**Antw: st: RE: xtpmg: saved results** - Previous by thread:
**Re: st: RE: Sorting in a table a list of binomial variables by frequency of apparition in a survey context** - Next by thread:
**Re: st: RE: Sorting in a table a list of binomial variables by frequency of apparition in a survey context** - Index(es):

© Copyright 1996–2023 StataCorp LLC | Terms of use | Privacy | Contact us | What's new | Site index |