Hi All:

I have two files. One looks like:

Faculty Course
Tom ACC 122
Bill BUS 220
Charles CIS 891

The other one looks like:

Course Student Grade
ACC 122 Lisa A
ACC 122 Nacy B
ACC 122 Jim A
BUS 220 Sue A
BUS 220 Carla B
CIS 891 Xu A
CIS 891 Ena C
CIS 891 Karen D

Is there any way I can merge these two files, or actually I want to add
faculty name to each student grade record. I know we can merge these two
files but the key variable Course is duplicated in the second file. I could
not use SPSS to merge them. I don't know Macro. Is there anyone who can
help me out? Thanks a lot.

Charles