With Stat/Transfer and stcmd works beautifully.
Many thanks again.
Angel Rodriguez-Laso
2008/10/16 Martin Weiss <[email protected]>:
> 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: [email protected]
> [mailto:[email protected]] On Behalf Of Ángel Rodríguez
> Laso
> Sent: Thursday, October 16, 2008 2:39 PM
> To: [email protected]
> 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 <[email protected]>:
>> 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: [email protected]
>> [mailto:[email protected]] On Behalf Of Ángel Rodríguez
>> Laso
>> Sent: Thursday, October 16, 2008 10:11 AM
>> To: [email protected]
>> 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 <[email protected]>:
>>> 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: [email protected]
>>> [mailto:[email protected]] On Behalf Of Ángel
> Rodríguez
>>> Laso
>>> Sent: Monday, October 13, 2008 12:28 PM
>>> To: [email protected]
>>> 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/
