I have table1 and table2
Trying to do a left join from Table1 to Table2
In table1 the key is Lamb
in table2 the key is Mary,had,a,Little,Lamb in one column
I want to join these tables on a key where table1 key matches the partial string in Table2. I want to bring back te results if Lamb is anywhere in the key.
Thanks,
paul
Really should provide some idea of the structure/contents of both tables and what the desired output may be.
Is something like this what your are looking for:
data table1; input word $; datalines; lamb Lamb sheep cow ; run; data table2; key= "Mary,had,a,Little,Lamb";output; key= "Sheep are not cows";output; run; proc sql; select table1.*, table2.* from table1, table2 where index(table2.key,strip(table1.word))>0; quit;
Details will be important. For example:
Does capitalization matter?
Partial words:
Does this contain Lamb: Lambaste,the,cowards
Does this contain sheep: shy,sheepish,timid
Does this contain sheep: wolf-in-sheep's-clothing
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.