Thank you- I think my mind was going faster than my fingers. I guess I am trying to link table 1 with table 2(translation) and then I would create three new columns (GATE, BASP, ADVCALC, BIOS) in table 3. If table 1 contained program = 8, mark "X" under column GATE in table 3. If program= 9 in table 1, Mark "X" for BASP in table 3 and if program=1 in table 1, mark "X" under ADVCALC in table 3. I would link by student, grade and school. PROC SQL not required- if data step will take care of it. Thank you Here is the first table: STUDENT GRADE SCHOOL PROGRAM E902 9 GARDEN 8 E902 9 GARDEN 9 E902 9 BELL 8 N233 9 BELL 8 E981 10 DINGLE 9 Second table: PROGRAM CODE PROGRAM 8 GATE 9 BASP 1 ADVCALC 2 BIOSC Would like my results to look like this: STUDENT GRADE SCHOOL GATE BASP ADVCALC N233 9 BELL X E981 10 DINGLE X E902 9 GARDEN X X
... View more