Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down on April 23, and its replacement, **statalist.org** is already up and running.

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

From |
"Kaulisch, Marc" <kaulisch@forschungsinfo.de> |

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

Subject |
AW: st: Spss vs Stata |

Date |
Wed, 4 Aug 2010 15:10:32 +0200 |

Shahrul, As SPSS understands Stata quite well, it is not a hassle to switch, but of course to do everything in Stata is the goal... I would be very happy to have a look at your programme. I do not find your e-mail address so I would be happy if you can sent me a message to kaulisch at forschungsinfo.de Marc -----Ursprüngliche Nachricht----- Von: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Shahrul Mt-Isa Gesendet: Mittwoch, 4. August 2010 14:53 An: statalist@hsphsun2.harvard.edu Betreff: Re: st: Spss vs Stata I find that it is more time consuming to keep switching programs to build tables etc. Having a structured table ready for publication is always ideal. Because normally creating pivot tables for example creating something from a -tab- output is common, it is best to spend a few hours to write a programme to do this. I've written a simple program to build table in .rtf format to give such tables in an .rtf file (although may need further formatting to make it look pretty in word). Happy to share. E-mail me if you'd like a copy of this program as I don't think I can send it as attachment here. The output looks somewhat like this [% (n)] (xx=masked figures as come from ongoing study): Female Male 0 xx.92 (xx) xx.61 (xx) 1 xx.42 (xx) xx.28 (x) 2 xx.25 (xx) xx.77 (xx) 3 xx.42 (xx) xx.51 (xx) A small tinkering using the same principles, you can achieve something like below (as a table but might not print properly here): com commis gps gpsmis No randomised xx xx Males (m/f) xx.x (xx/xx) 0 xx.x (xx/xx) 0 Age(yrs) 0 0 Mean(sd) xx.5 (xx.4) xx.4 (xx.0) Med(IQR) xx.1 (xx.6-xx.0) xx.7 (xx.0-xx.8) Hypertension xx.0 (xx) 0 xx.7 (xx) 0 Fam hist of diabetes xx.5 (xx) 0 xx.1 (xx) 0 BW, Shahrul ******************************* Shahrul Mt-Isa Statistician Imperial Clinical Trials Unit, School of Public Health, Imperial College London, Norfolk Place, London W2 1PG. ******************************* Date: Tue, 03 Aug 2010 10:27:29 +0200 From: SCHOUMAKER Bruno <bruno.schoumaker@uclouvain.be> Subject: Re: st: Spss vs Stata if I am wrong) only one column variable (but multiple row variables). Bruno Le 2/08/2010 16:43, Neil Shephard a écrit : > n Mon, Aug 2, 2010 at 2:30 PM, Kaulisch, Marc > <kaulisch@forschungsinfo.de> wrote: > >> I am more concerned about the flexibility to generate pivot tables than about pretty tables. >> > I've no idea what a "pivot table" is, but if the structure below.... > > >> My previous example in http://www.stata.com/statalist/archive/2009-11/msg00238.html was: >> Table >> Rowvar colvar1 colvar2 >> 1 2 1 2 3 >> n C% n C% n C% n C% n C% >> 1 >> 2 >> 3 >> Total >> >> In order to avoid weeks of Stata programming etc. we decided to generate those tables in SPSS. >> >> > You could likely achieve it using Ian Watson's -tabout- (available on > SSC) or likely achieve it from first principles using > -contract-/-collapse- in conjunction with some -append-/-merge- and a > small amount of programming. > > Although of course I've assumed that you know how to do this sort of > programming, and if not it may well take "weeks", but next time it > will take you far less, and eventually it will become second nature if > you use Stata regularly. > > Neil > - -- Bruno SCHOUMAKER Centre de recherche en démographie et sociétés Université catholique de Louvain 1-17 PLace Montesquieu 1348 Louvain-la-Neuve BELGIUM Tel. +32 10 474136 Fax. +32 10 472952 bruno.schoumaker@uclouvain.be www.uclouvain.be/demo * * 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**:**AW: st: Spss vs Stata***From:*"Dr. Martin Weiss" <martin.weiss1@gmx.de>

- Prev by Date:
**AW: st: Emily's fall school dates** - Next by Date:
**AW: st: Spss vs Stata** - Previous by thread:
**Re: st: Spss vs Stata** - Next by thread:
**AW: st: Spss vs Stata** - Index(es):