[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 |
Fri, 17 Oct 2008 13:55:41 +0200 |

With Stat/Transfer and stcmd works beautifully. Many thanks again. Angel Rodriguez-Laso 2008/10/16 Martin Weiss <martin.weiss1@gmx.de>: > 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/ > * * 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:
**st: RE: Re: distance data missing values** - Next by Date:
**st: RE: RE: Re: distance data missing values** - 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:
**Fwd: AW: st: question about rolling regression and nlcom** - Index(es):

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