Hi All,
I was trying to merge the following two table, can someone tell me how do I get my desired output? Thanks
I tried the following:
DATA Want; MERGE Table1(in=a) Table2(in=b); BY state; IF a=1; RUN;
Table 1:
ID State
101 NY
101 TX
Table 2:
State Day Time
NY MON 7:00 - 8:00
NY TUES 10:00 - 10:30
NY WED 11: - 11:45
TX FRI 8:00 - 9:30
TX SAT 10:00 - 11:00
TX MON 9:00 - 11:00
Output:
ID State Day Time
101 NY MON 7:00 - 8:00
101 NY TUES 10:00 - 10:30
101 NY WED 11: - 11:45
101 TX FRI 8:00 - 9:30
101 TX SAT 10:00 - 11:00
101 TX MON 9:00 - 11:00
I want all three observation of each by group (since they are unique observation) in Table2 merge with each observation of Table1.
... View more
