@dmbuffum3 wrote:
Windows experts please help! Thanks in advance.
The following SAS code runs for more than a few days and fails to complete. It issues a recursive Windows DIR command with which I want to gather the following metadata on all the files on a large Windows fileserver.
folder_path
file_name
file_extension
file_owner
file_size_bytes
file_last_access_datetime
file_last_written_datetime
file_last_read_datetime
I estimate there are >5 million files on this fileserver based on the following results.
I might suggest breaking this into a few smaller jobs so that you have different root directories and save each to a different data set.
dir "\\fsprod109\MTKA Public\somefolder\*"
That way you may get some useable data without having to wait "days".
Performance related to network drives may be fun to address. Bandwidth, permissions, priorities and the every popular network security rules may have an impact.
... View more