topic Re: How find Excel file name,created date in particular path in SAS Programming

How find Excel file name,created date in particular path

thanikondharish — Sat, 03 Aug 2019 10:00:24 GMT

D:/folder1.
In my D drive there is one folder name is Folder1.
In Folder1 there is one Excel file.
How find that excel filename and that file created date like see below....
File_name. Time
Students.xlsx. 10:23:22

Re: How find Excel file name,created date in particular path

andreas_lds — Sat, 03 Aug 2019 10:38:18 GMT

Can you use os-commands in your sas-session?

If not, use the functions dopen, dread and finfo to get the information.

Re: How find Excel file name,created date in particular path

thanikondharish — Sat, 03 Aug 2019 10:40:43 GMT

How to write code

Re: How find Excel file name,created date in particular path

andreas_lds — Sat, 03 Aug 2019 10:44:23 GMT

@thanikondharish wrote:
How to write code

You haven't answered my question. When you read the documentation of the functions i mentioned you should be able to write the data-step.

Re: How find Excel file name,created date in particular path

thanikondharish — Sat, 03 Aug 2019 10:46:43 GMT

Yes

Re: How find Excel file name,created date in particular path

VDD — Sat, 03 Aug 2019 14:50:42 GMT

@thanikondharish How to write code

you practice,

here is one way bring up a DOS or a PowerShell window and type help.

C:\> help

C:\> help fc

Re: How find Excel file name,created date in particular path

Kurt_Bremser — Sat, 03 Aug 2019 18:56:01 GMT

@thanikondharish wrote:
How to write code

I mostly use a keyboard.