data have1;
input folder1 :$60. ;
cards;
F:/Drive1/Dataset/Table1
F:/Drive2/Dataset/Table2
F:/Drive3/Table
F:/Drive4
;
data have2;
input folder2 :$60. linux $60.;
cards;
F:/Drive1 /sas/data/drive1
F:/Drive2 /sas/data/drive2
F:/Drive1/Dataset /sas/data/dataset
F:/Drive2/Dataset /sas/data/dataset
F:/Drive3/ /sas/data/drive3
;
proc sql;
create table test as
select *
from have1, have2
where scan(folder1,1,'/') =scan(folder2,1,'/') ;
quit;
data a;
set test;
folder1 = tranwrd(folder1,folder2,linux);
run; The Tranwrd function is not working well (no replacement done). Any ideas? Thank you
... View more
