Hi! I need to merge two tables, but the 2 variables that I'm matching on don't match exactly. The variable in the first table is 11 characters and the other is 9 (between the 2nd and 9th digit of the first). I would like to do this in a proc sql step if possible.
data table1;
input text$20.;
cards;
z2345678900
x3333333300
;
data table2;
input text$;
cards;
23456789
33333333
;
proc sql;
create table want as select a.text, b.text as text2 from table1 as a , table2 as b where substr(a.text,2,8)=b.text;
quit;