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

Go to Data - Text to Columns and use "comma" as a separator in the dialog box... That is not so much a Stata but an Excel issue, though... You might also consider Stat/Transfer in conjunction with the -ssc d stcmd- package which would spare you the Excel issue... 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 2:39 PM 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 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/ * * 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>

**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:
**Re: st: RE: Sorting in a table a list of binomial variables by frequency of apparition in a survey context** - Next by Date:
**RE: st: lincom - how are standard errors calculated?** - Previous by thread:
- Next by thread:
- Index(es):

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