topic Returning Filenames & Creation Date in a directory (i.e unix ls -l)? in SAS Procedures

Returning Filenames & Creation Date in a directory (i.e unix ls -l)?

jammy — Sun, 02 Feb 2014 19:25:09 GMT

Hi,

I'm trying to get all the filenames (.csv) in a directory & want the creation date of the file, like the unix command ls -l.

I can get some details using list but it wont give me the year.

This is what I have done:

filename dir_lst ftp '' cd="&EMFTDIR" list user=&qemftname host="&host" pass= &qemftpwd;

data files_list; attrib a b c d e f g h i length=$30;

infile dir_lst dlm=' ' firstobs=1;

input a b c d e f g h i ;

run;

Is there something else I can use to return the filename & creation date?

Thanks

Re: Returning Filenames & Creation Date in a directory (i.e unix ls -l)?

LinusH — Sun, 02 Feb 2014 21:00:14 GMT

Do you need tio use ftp?

You could use a remote shell/telnet and filename pipe, or pipe to a temporary file.

Re: Returning Filenames & Creation Date in a directory (i.e unix ls -l)?

jammy — Sun, 02 Feb 2014 21:17:21 GMT

i think so, as I'm using EG & need to read a directory not on a SAS server.

Re: Returning Filenames & Creation Date in a directory (i.e unix ls -l)?

Tom — Mon, 03 Feb 2014 05:03:48 GMT

The format returned by the LIST command usually depends on the host that you have connected to.

If you use ls -l on Unix then for files created within the last 6 months it does not return the year, instead it uses that space on the line to display the time.

Perhaps your FTP server is working the same way?

You can figure out the year.

Re: Returning Filenames & Creation Date in a directory (i.e unix ls -l)?

jammy — Mon, 03 Feb 2014 19:11:02 GMT

thanks Tom, that's right - I was wondering why my new files had a time & some had the year (need to brush up on Unix)!

I've just coded round it.

cheers