Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


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

RE: st: Presenting data in a desired form


From   "David Radwin" <dradwin@mprinc.com>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: Presenting data in a desired form
Date   Thu, 24 Jun 2010 14:59:30 -0700 (PDT)

You are welcome. I don't know the specifics offhand, but if you want to
use mail merge, you need to start with an Excel-type spreadsheet
(tab-separated text or comma-separated text) with one line per student. 

Since you have multiple lines per student right now, you probably want to
use Stata's -reshape wide- to consolidate the records. Then use -outsheet-
to create the Excel-type spreadsheet. Stata's -help reshape- and -help
outsheet- should assist you here. The website to which I previously
referred has instructions on creating the interface with your email
program.

As you might infer from the website's references to Word 2000 and 2002, it
was quite a while ago that I last did this, and the software may have
changed in the interim, so I am afraid can't help much more with the
details.

Best of luck.

David

--
David Radwin
Research Associate
MPR Associates, Inc.
2150 Shattuck Ave., Suite 800
Berkeley, CA 94704
Phone: 510-849-4942
Fax: 510-849-0794

www.mprinc.com


> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-
> statalist@hsphsun2.harvard.edu] On Behalf Of keeler james
> Sent: Thursday, June 24, 2010 2:46 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: RE: st: Presenting data in a desired form
> 
> Many thanks for the tips, David.
> 
> I have tried Martin's method and it works well in separating the
> candidates in individual files. I shall now work on arranging the data
> into the desired format. Any tips on this?
> 
> 
> Calchas
> 
> 
> 
> 
> _________________________________________________________________
> http://clk.atdmt.com/UKM/go/195013117/direct/01/
> 
> *
> *   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/


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