Thank you all for your help. I have a follow up on this question that I posted earlier
https://communities.sas.com/t5/Base-SAS-Programming/question-on-substring/m-p/293499#M61090
my table A is as before only consistent of the below
code
35
10
20
50
3540
36x40
table B
code
a35,a90
a36,a3540
zz72
jj36x40, jj3640,jj72
a10,x1010
I would like the output to be table B where I would like to add an extra column which has the only those codes which are available in table A
table B
code codenew
a35,a90 a35
a36,a3540 a3540
zz72
jj36x40, jj3640, jj72 jj36x40
a10,x1010 a10
THanks again for your help
I tried with find but I am not getting the answer I want if there is any other function whcih can help me do this.
Thanks so much
... View more