If you have 3 records for a key in dataset1, and 2 records for a key in dataset2, a merge in a data step by that key will give you 3 records, the join in SQL will give you 6 (cartesian product).
... View more
When you select into a macro variable without specifying that it concatenate the results by using the SEPARATED BY clause then PROC SQL will only return the first record. 266 proc sql noprint ; 267 select name into :name trimmed 268 from sashelp.class 269 order by name desc 270 ; 271 %put &=sqlobs &=name ; SQLOBS=1 NAME=William 272 quit;
... View more
