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 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]

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   Wed, 23 Jun 2010 21:41:03 -0700 (PDT)

I did this some years ago, when I was a lowly teaching assistant, using Microsoft Word's mail merge feature. It has the added advantage of enabling you to automatically email the grades, although you should first check applicable government and campus regulations regarding sending student grades and other personal information by email. You could probably accomplish the same thing using the open source alternatives to Word/Excel, OpenOffice or NeoOffice.

See http://davidradwin.com/teaching/ for instructions.

You'll need to -reshape wide- and -outsheet- your grades in Stata first, so Martin's solution may be preferable.

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: "keeler james" <keelercalchas@hotmail.com>
To: statalist@hsphsun2.harvard.edu
Sent: Wednesday, June 23, 2010 3:25:03 PM
Subject: st: Presenting data in a desired form

Dear Statalist,

Good evening!

If I have a data set in the Stata editor as follows:

Name CandidateNo Subject Grade Mark
1. xxx 1234 English A 80
2. xxx 1234 Maths B 65
3. xxx 1234 Chemistry C 55
4. yyy 0165 English D 40
5. yyy 0165 Maths E 30
6. zzz 3656 English C 50
7. zzz 3656 Maths B 67


Q1. How can I separate each candidate in an individual txt file with all
their subjects in it?

Q2. How can I arrange the data in the following form?

_________________________________

Name CandidateNo
xxx 1234

Subject Grade Mark
English A 80
Maths B 65
Chemistry C 55
_________________________________

Any help will be highly appreciated - also any book/webpage I can read
relating to this?

Calchas

*
*   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