topic Re: execute windows command in FILENAME statement in SAS Programming

execute windows command in FILENAME statement

arunrami — Tue, 26 Nov 2019 15:55:08 GMT

I am using following sas code to read the file from the window host directory , is there any way that I can get the recently modified date and file size along with that ?

filename indir ftp cd= "&directory_window." ls user="&user_name_window."
host= "&window_host." pass="&password_window." debug;



data Files(where=(File_Name like "%akj%" and index(File_Name,'csv')));
infile indir;
input File_Name $300.;
put _INFILE_;
run;

- SAR

Re: execute windows command in FILENAME statement

Tom — Tue, 26 Nov 2019 16:06:35 GMT

You are not running a windows commad. You are using SAS's FTP engine.

What if you use your own Windows command to run an FTP command? Then you can issue whatever FTP commands your want.

Note that the issue might be what the FTP server you are connecting to can actually produce. Different FTP server implementations might offer different comamnds and options. Try connecting to the server using FTP and see what it supports.