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

From |
"Ángel Rodríguez Laso" <angelrlaso@gmail.com> |

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 14:38:41 +0200 |

It doesn't work. I get in Excel something very similar to what I got copying the -list- output, all variables from each observation (disease) in the same cell, separated by commas: eq,estimate,ci hypertension,14.3,"(12,6-16,1)" artrosis,14.0,"(12,1-15,8)" alergy,10.4,"(8,8-12,1)" . . . Note that ci is a new string variable obtained from min95 and max95, but I don't think this matters. Best regards, Angel 2008/10/16 Martin Weiss <martin.weiss1@gmx.de>: > 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/ > * * 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: RE: Sorting in a table a list of binomial variables by frequency of apparition in a survey context***From:*"Martin Weiss" <martin.weiss1@gmx.de>

**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: RE: Use foreach or forvalues to create the long form data** - Next by Date:
**RE: st: RE: Sorting in a table a list of binomial variables by frequency of apparition in a survey context** - 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:
- Index(es):

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