Date: Thu, 2 Feb 2012 10:32:46 +0000
Reply-To: "Balmer, Thomas" <Thomas.Balmer@phbern.ch>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Balmer, Thomas" <Thomas.Balmer@phbern.ch>
Subject: De-Aggregation?
Content-Type: multipart/alternative;
Hello
I've got a database with the following structure:
ID-Course
Coursegroup
course
Name
city
11
1
1
A
11
1
1
B
11
1
1
C
12
1
2
D
12
1
2
E
12
1
2
F
13
1
3
A
13
1
3
G
21
2
1
H
21
2
1
I
21
2
1
D
31
3
1
J
31
3
1
K
32
3
2
L
32
3
2
B
32
3
2
M
According to my knowledge it's an aggregated database on the level of ID-Course. In order to analyze, for instance the origin oft the participants, their age etc., I've got to "de-aggregate" this database to have the unique participants as cases and it should look like this :
Name
ID-Course1
ID-Course2
city
A
11
13
B
11
32
C
11
D
12
21
E
12
F
12
G
13
H
21
I
21
J
31
K
31
L
32
M
32
Am I right ? Or are there other possibilities? And how could I do that?
Thanks for any help.
Tom
[text/html]
| 
