Sorry for the long wait. Here's the Log: 4165 +*filename FlistCB4 pipe "dir /s/b/a-d ""\\danskenet.net\public\Dat\4841CPM\28 Kredit\15
4165 !+Green Loans\*.xlsx""";
4166 +filename FlistCB4 pipe "dir /s/b/a-d ""I:\Dat\4841CPM\28 Kredit\15 Green Loans\*.xlsx""";
4167 +
4168 +
4169 +data FlistIOME;
4170 + infile FlistCB4 lrecl=500 truncover;
4171 + input this_file $500.;
4172 + attrib
4173 + Folder_Name length=$60
4174 + Filename length=$60
4175 + Date format=yymmdd10.
4176 + HAT length=$8
4177 + hat2 length=$4
4178 + ;
4179 + /* remove all rows with folder names not complying with naming convention */
4180 + Folder_Name=scan(this_file,-2,'/\');
4181 + Filename=scan(this_file,-1,'/\');
4182 + HAT=substr(Filename,length(Filename)-12,8);
4183 + Date=input(substr(Filename,length(Filename)-12,8),yymmdd10.);
4184 + hat2=substr(Filename,length(Filename)-3,4);
4185 + hat3=substr(Filename,1,11);
4186 + if upcase(HAT3)='GREEN_LOANS';
4187 + if not missing(Date) ;
4188 +run;
NOTE: The infile FLISTCB4 is:
Unnamed Pipe Access Device,
PROCESS=dir /s/b/a-d "I:\Dat\4841CPM\28 Kredit\15 Green Loans\*.xlsx",
RECFM=V,LRECL=500
Stderr output:
Invalid Signature.
NOTE: 0 records were read from the infile FLISTCB4.
NOTE: The data set WORK.FLISTIOME has 0 observations and 7 variables.
... View more
