There are 2 datasets, names and partners. In partners , id is given but we need to find corresponding names using "names" dataset data names; input st_id st_names $; datalines; 1 John 2 Mark 3 Steve 4 Smith 5 Cook 6 Messi 7 Mary 8 Kris 9 Kevin ; run; data partners; input st_id1 st_id2 st_id3; datalines; 1 4 7 2 5 8 ; run; I need to add 3 columns in dataset partners name_id1,name_id2,name_id3 . To get names from dataset "names" as per id , i think we need to join dataset 3 times. What if datasets has million of records, is there any way we can simply the joins?
... View more