topic FINFO function returns null value in New SAS User

FINFO function returns null value

sdemirel — Thu, 02 Sep 2021 11:47:38 GMT

Hi everyone,

I want to get the last modified date of a located file with FINFO function. I am using following code part for this but I am not getting any value and "modifydt" returns null. Could you please give a feedback on how I should fix this? thanks in advance.

SAS Enterprise Guide Version: 7.15

Program:

data info (keep=modifydt);
rc = filename("onefile","C:\Users\sdmrl\Desktop\test.xls");
fid = fopen("onefile");
modifydt = FINFO(fid,"Last Modified");
run;

Re: FINFO function returns null value

Kurt_Bremser — Thu, 02 Sep 2021 11:52:48 GMT

Most likely your SAS workspace server process is running on a remote server and does not have access to your desktop computer's storage.

Re: FINFO function returns null value

ballardw — Thu, 02 Sep 2021 12:11:03 GMT

@sdemirel wrote:

Hi everyone,

I want to get the last modified date of a located file with FINFO function. I am using following code part for this but I am not getting any value and "modifydt" returns null. Could you please give a feedback on how I should fix this? thanks in advance.

SAS Enterprise Guide Version: 7.15

Program:
data info (keep=modifydt);
rc = filename("onefile","C:\Users\sdmrl\Desktop\test.xls");
fid = fopen("onefile");
modifydt = FINFO(fid,"Last Modified");
run;

If your value for RC is anything other than 0 the filename statement failed to assign a fileref.

If your value for FID is 0 it failed to open the file.

In either of the above fail then pretty much expect FINFO to fail.

Re: FINFO function returns null value

sdemirel — Thu, 02 Sep 2021 12:17:41 GMT

Hi @ballardw ,

I checked the values for both and it seems to RC and FID is zero ('0'). In this case, it failed to open the file