@Tom You are right. How to tackle now? I'd to like to how to write proc transpose from proc sql join? ... View more

May be I would have phrased in wrong way. Yes, I have to check specific string of digits that appears between underscore and copy the file to the target folder if the string of digits matches. ... View more

@Kurt_Bremser Your fix has worked, thank you.I do have one more question. I tried to add two more 'else if' condition in the program and also added one macro variable but it's not working. Objective is to move the file  to the destination folder based on the value of macro variable and if file name has string '_copied'. After copying it I've to remove the string '_copied' in the target folder. I yet to add this logic as I couldn't find any so far.   Source folder is always same for any files. Macro variable and else if which I added in the @Tom program are,   %let function=NL; /*added*/ else if scan(lowcase(filename),-1,'.')='csv' and index(lowcase(filename),'_copied.csv ') and "&function" EQ 'NL' then do; source="&inpath" ||"/"|| filename; target="&path2"||"/"||filename; end; /*added*/ else if scan(lowcase(filename),-1,'.')='csv' and index(lowcase(filename),'_copied.csv ') and "&function" EQ 'LH' then do; source="&inpath" ||"/"|| filename; target="&path1"||"/"||filename; end; Error message: 26 %let function=NL; 27 28 %let inpath=/var/sasdata/GTM; 29 %let path1=/var/sasdata/LH; 30 %let path2=/var/sasdata/NL_GTM; 31 32 filename source "&inpath"; 33 34 data files ; 35 length id 8 msg filename source target $256 ; 36 did=dopen("source"); 37 if did<=0 then do; 38 msg=sysmsg(); 39 put msg; 40 stop; 41 end; 42 do id=1 to dnum(did); 43 filename=dread(did,id); 44 if scan(lowcase(filename),-1,'.')='csv' and not index(lowcase(filename),'_copied.csv ') then do; 45 source="&inpath" ||"/"|| filename; 46 if indexw(filename,'5601','_') or indexw(filename,'6010','_') or indexw(filename,'6020','_') then do; 47 target="&path1"||substr(filename,1,length(filename)-4)||'_copied.csv'; 48 end; 49 else if indexw(filename,'0169','_') or indexw(filename,'1070','_') or indexw(filename,'0417','_') then do; 50 target="&path2"||"/"||filename; 51 end; 52 /*added*/ 53 else if scan(lowcase(filename),-1,'.')='csv' and index(lowcase(filename),'_copied.csv ') and "&function" EQ 'NL' 53 ! then do; 54 source="&inpath" ||"/"|| filename; 55 target="&path2"||"/"||filename; 56 end; 2 57 /*added*/ 58 else if scan(lowcase(filename),-1,'.')='csv' and index(lowcase(filename),'_copied.csv ') and "&function" EQ 'LH' 58 ! then do; 59 source="&inpath" ||"/"|| filename; 60 target="&path1"||"/"||filename; 61 end; 62 else target="&path1"||"/"||filename; 63 end; 64 output; 65 end; 66 did=dclose(did); 67 drop did msg; 68 run; NOTE: The data set WORK.FILES has 1 observations and 4 variables. NOTE: Compressing data set WORK.FILES increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 69 70 data files_moved; 71 set files ; 72 length rc1-rc4 8 msg $256 ; 73 rc1=filename('from',source); 74 rc2=filename('to',target); 75 rc3=fcopy('from','to'); 76 if rc3 then do; 77 msg=sysmsg(); 78 put 'ERROR: Unable to copy. ' source= target= rc3= msg=; 79 end; 80 else do; 81 rc4=fdelete('from'); 82 end; 83 output; 84 rc1=filename('from'); 85 rc2=filename('to'); 86 run; ERROR: Unable to copy. SOURCE= TARGET= RC3=20004 MSG=ERROR: No logical assign for filename FROM. NOTE: There were 1 observations read from the data set WORK.FILES. NOTE: The data set WORK.FILES_MOVED has 1 observations and 9 variables. NOTE: Compressing data set WORK.FILES_MOVED increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds Any leads to help resolve this error and the logic to remove the string '_copied' from the filename in the target folder?     ... View more

Thank you for letting me know. How to tackle with parenthesis? May I request to check the whether the parenthesis are placed correctly in the posted example? ... View more

Source data is connected with only calendar quarter. ... View more

I gave the example values and the format I used in the initial post ... View more

Is it possible for you to show me with my example data and the format which I applied and then applying the filters? ... View more