It will run, it just doesn't do anything useful.
data table1;
input id FirstName $10.;
datalines;
1 Tom
2 Richard
3 Harry
;
run;
data table2;
input id HomeTown $10.;
datalines;
2 Boston
3 Miami
4 Nome
;
run;
proc sql;
SELECT table1.ID,
table1.FirstName,
(SELECT HomeTown FROM table2 WHERE table2.ID=table1.ID) as hometown
FROM table1, table2;
quit;
Provides
The SAS System 09:15 Monday, December 18, 2017 2 id FirstName hometown 1 Tom 1 Tom 1 Tom 2 Richard Boston 2 Richard Boston 2 Richard Boston 3 Harry Miami 3 Harry Miami 3 Harry Miami
... View more
