topic Tranwrd with variables in SAS Programming

Tranwrd with variables

alexlor — Tue, 29 Aug 2017 21:43:39 GMT

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

Re: Tranwrd with variables

WarrenKuhfeld — Tue, 29 Aug 2017 22:23:03 GMT

try trimming folder2: trim(folder2)

Re: Tranwrd with variables

Shmuel — Tue, 29 Aug 2017 22:50:56 GMT

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

Did you mean:

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

Re: Tranwrd with variables

Tom — Tue, 29 Aug 2017 23:53:56 GMT

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));