Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

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

Re: st: Presenting data in a desired form

From   David Radwin <>
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 for instructions.

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


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

----- Original Message -----
From: "keeler james" <>
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?


*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index