I'm currently working on a project that involves utilizing PROC SQL for data manipulation, and I've encountered a challenge with a particular JOIN operation. Specifically, I am trying to join two tables using PROC SQL, and despite double-checking my syntax, I seem to be getting unexpected results. Here's a simplified version of the query: PROC SQL; CREATE TABLE CombinedTable AS SELECT A.*, B.* FROM TableA A LEFT JOIN TableB B ON A.ID = B.ID; QUIT;   Despite seemingly correct syntax, I'm not getting the expected results. Has anyone else experienced a similar issue with PROC SQL joins, or is there something I might be overlooking? Any insights, suggestions, or examples would be greatly appreciated. ... View more