De-Aggregation?

[Tom]

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

[David Marso]

MATCH FILES / FILE * / KEEP ID_Course NAME City.
SORT CASES BY NAME.
CASESTOVARS/ID=name.