topic Read .XLS Date and time modified into SAS dataset in New SAS User

Read .XLS Date and time modified into SAS dataset

RADAGBE9 — Mon, 23 Dec 2019 13:34:34 GMT

I have a folder containing multiple excel files that I need to read and combine to one single SAS dataset. Is there a way I can add the modified date and time in my dataset?

For example:

if the excel workbook was saved in a folder on 12/23/19 6:00 AM, can we include " 12/23/19 6:00 AM" in the dataset?

Thanks

Re: Read .XLS Date and time modified into SAS dataset

Kurt_Bremser — Mon, 23 Dec 2019 13:57:16 GMT

Look at the fopen, foptnum, foptname and finfo functions. Or run the appropriate external command to retrieve the information.

Re: Read .XLS Date and time modified into SAS dataset

japelin — Mon, 23 Dec 2019 14:04:06 GMT

how about this code?

%let target=c:\temp;/* specify target folder including xls files. */
filename cmd pipe "dir /s &target | findstr .xls";
data xlslist;
  infile cmd;
  length dtc $17;
  input;
  dtc=substr(_infile_,1,17);
run;