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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: