home *** CD-ROM | disk | FTP | other *** search
- Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
- Path: sparky!uunet!paladin.american.edu!auvm!HUB.UCSB.EDU!VELASCO
- Message-ID: <9208252208.AA29811@alishaw.ucsb.edu>
- Newsgroups: bit.listserv.sas-l
- Date: Tue, 25 Aug 1992 15:08:56 PDT
- Reply-To: Steve Velasco <velasco%alishaw@HUB.UCSB.EDU>
- Sender: "SAS(r) Discussion" <SAS-L@UGA.BITNET>
- From: Steve Velasco <velasco%alishaw@HUB.UCSB.EDU>
- Subject: Merging Data Sets
- Comments: To: SAS-L@uga.cc.uga.edu
- Lines: 47
-
- Contents: Question about merging data sets.
- Rlse/Pltfm: 6.07/Unix(SunOS 4.1)
- Name: Steven Velasco
- E-Mail: velasco@alishaw.ucsb.edu
- Voice: (805)562-1642
-
- Hello SAS-L,
-
- I have a question about merging data sets that I hope someone out there
- can answer.
-
- I have two data sets, one has student level data and the
- other school level data, of the following form:
-
- A) STUDENT LEVEL DATA | B) SCHOOL LEVEL DATA
- CASEID SCHOOLID VAR1...VARN | SCHOOLID VARS1...VARSN
- ------ ------- ---------- | -------- -------------
- 100011 1000 X ... X | 1000 X ... X
- 100012 1000 X ... X | 1001 X ... X
- 100013 1000 X ... X | 1002 X ... X
- 100111 1001 X ... X | 1003 X ... X
- 100112 1001 X ... X | 1004 X ... X
- 100113 1001 X ... X | 1005 X ... X
- : | :
- : | :
- : | 1999 X ... X
- : |
- : |
- 1999XX 1999 X ... X |
-
- There are about 28,000 students in approximately 1000 schools,
- with 135 student level variables, and 235 school level variables.
-
- As you can see, there are numerous students with the same "SCHOOLID"
- in the student level data. What I would like is a data set that
- has all school level variables for each student that attended a particular
- school. For example, for each student that attended school 1000, I would
- like to have the relevant school level data merged to their responses.
-
- It seems that SAS should be able to do something like this, but looking
- at the manuals it is not immediately apparent to me how.
-
- Any help will be very much appreciated.
-
- Please E-Mail responses to:
- Steven C. Velasco
- velasco@alishaw.ucsb.edu
-