Tranwrd with variables

[alexlor]

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

[WarrenKuhfeld]

try trimming folder2: trim(folder2)

[Shmuel]

In all your rows:  scan(folder1,1,'/')  ='F:'= scan(folder2,1,'/');

Did you mean:

    where scan(folder1, -1,'/') = trim(folder2)

[Tom · Accepted solution]

You need to trim the values passed to the TRANWRD() function since SAS stores variables as fixed length.  You asked tranwrd to find values with many trailing spaces that are probably not actually in the values.

linux_folder1 = tranwrd(folder1,trim(folder2),trim(linux));