Both observations display the same date. ... View more

Thanks, Tom!  That was a problem with the year being missing for the most recent six months, but I had a work around that was effective.  I like yours also and it works except for the ls option.  I guess I have an older version.  😞  Do you know why when I put the date into a macro, it changes?  The actual value for moddt2 is 20170330 with a date format and moddt1 is Mar302017 with a charater format.  when I use symput to put them into macros, &moddt2 is 20170209 and &moddt1 is Feb092017.   36 data dssinf1; 37 infile _dssinf1 pad recfm=v lrecl=1024 firstobs=2; 38 39 input filename $200.; 40 listinfo=compbl(filename); 41 rwa = scan(listinfo,1,' '); 42 nm = scan(listinfo,2,' '); 43 userid = scan(listinfo,3,' '); 44 dbs = scan(listinfo,4,' '); 45 size= scan(listinfo,5,' '); 46 mon= scan(listinfo,6,' '); 47 day= scan(listinfo,7,' '); 48 yr=scan(listinfo,8,' ');recnum=_n_; 49 if index(yr,':') then do; 50 time = yr; 51 year = year(today()); 52 if input(cats(day,mon,year),??date9.) > today() then year=year-1; 53 end; 54 else do ; 2 The SAS System 08:34 Thursday, March 30, 2017 55 time='00:00'; 56 year = input(yr,4.); 57 end; 58 59 60 *yr1=year(today()); 61 moddt=input(catx('-',mon,day,year),anydtdte11.); 62 call symput('moddt',moddt); 63 format moddt yymmddn8.; 64 moddt2=put(moddt,yymmddn8.); 65 moddt1=cats(mon,day,year); 66 call symputx('moddt1',moddt1); 67 call symputx('moddt2',moddt2); 68 typ= scan(scan(listinfo,9,' '),2,.); 69 fnam = scan(listinfo,9,' '); 70 if scan(fnam,1,.) IN ('filtered_odm_dss','filtered_odm_ufe'); 71 72 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 62:22 68:35 70:16 NOTE: The infile _DSSINF1 is: Pipe command="cd '/hasaspmt/fraud/facility/';ls -la " NOTE: 73 records were read from the infile _DSSINF1. The minimum record length was 59. The maximum record length was 93. NOTE: The data set WORK.DSSINF1 has 2 observations and 18 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.02 seconds   73 %put &moddt. &moddt1. &moddt2.; 20859 Feb092017 20170209   ... View more

Sorry, I've been working on this a few days and I made the correction manually yesterday, but I'll need to use this process again.  The date in the variable is correct as 20170328 but the macro keeps showing as 20170209, no matter what date the variable I created it from holds.   moddt=input(catx('-',mon,day,yr1),anydtdte11.); moddt2=put(moddt,yymmddn8.); call symputx('moddt2',moddt2);  %put &moddt. &moddt2.; 20859 20170209   The solution you provided using 'mdy' instead causes the variable to display as missing '.' and creates the errors below.   NOTE: Invalid argument to function INPUT at line 52 column 11. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed.   ... View more

Thank you.  Yes, I used pipe.  Here is the code.  You can see from the attached picture that the date variable is 20170118.  I placed the code in the attachment with the picture because they go together and I was not able to insert the picture here.  I don't know where the interpretation of 20170209 comes from.   48 %put &rundate ; 20170329 49 filename _dssinf1 pipe "cd '/hasaspmt/fraud/facility/';ls -la"; 50 51 data dssinf1; 52 infile _dssinf1 pad recfm=v lrecl=1024 firstobs=2; 53 54 input filename $200.; 55 listinfo=compbl(filename); 56 rwa = scan(listinfo,1,' '); 57 nm = scan(listinfo,2,' '); 58 userid = scan(listinfo,3,' '); 59 dbs = scan(listinfo,4,' '); 60 size= scan(listinfo,5,' '); 61 mon= scan(listinfo,6,' '); 62 day= scan(listinfo,7,' '); 63 recnum=_n_; 64 65 yr=scan(listinfo,8,' '); 66 yr1=year(today()); 67 moddt=input(catx('-',mon,day,yr1),anydtdte11.); 68 call symput('moddt',moddt); 69 format moddt yymmddn8.; 70 moddt2=put(moddt,yymmddn8.); 71 call symputx('moddt2',moddt2); 72 typ= scan(scan(listinfo,9,' '),2,.); 73 fnam = scan(listinfo,9,' '); 74 if scan(fnam,1,.) IN ('filtered_odm_dss','filtered_odm_ufe'); 75 76 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 68:22 72:35 74:16 NOTE: The infile _DSSINF1 is: Pipe command="cd '/hasaspmt/fraud/facility/';ls -la" NOTE: 72 records were read from the infile _DSSINF1. The minimum record length was 59. The maximum record length was 93. NOTE: The data set WORK.DSSINF1 has 2 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.00 seconds   77 %put &moddt. &moddt2.; 20859 20170209   ... View more