data find; input diseaseName $160. code $45.; datalines; cervical cancer 123.z HepA 9970 ; run; Hello team, I want to find a string within another string, if it is found, then grab the correspondent values from another variable. For example, if value of cervical if found in cervical cancer, then grap the character 123.z. Any help is greatly appreciated.   Regards, blue & blue ... View more

Hello all, I have 64 rows and I need to find them in a bigger data set. Here, my inquiry is about the logic that I have applied. I did a left outer join with missing on the second dataset and I was able to find those rows that exist in the first/left dataset, but it doesn't exist in the second/right dataset. The result came 4 rows.   Then I did inner join between first and second dataset with Distinct values and came 54 rows. If I do without distinct, the result is 169 rows.    54+4 equal to 58 and deduct it from 64, we have 6 rows left, which I don't know what is going about them. Can we say since we put distinct, we removed duplicates, in fact those 6 rows are among those 54 rows, they are just taken away by Distinct because they are duplicates. Here, I am looking for logic. I need to know the way I elaborate it is correct. I need to present it to my boss. Regards, Blue&Blue ... View more