topic Re: Include date of file when importing in SAS Procedures

Include date of file when importing

mjheever — Fri, 21 Feb 2014 07:52:32 GMT

Hi SAS Community!

Is there a way to create a date variable when importing a .csv file ?

In other words, I want to import the file, and then additionally I want to create a new variable (that will be included in the data set) to display the date of when the file was created.

Do you guys have any suggestions ?

Thank you!

Re: Include date of file when importing

Barnipaz — Fri, 21 Feb 2014 09:26:48 GMT

In a datastep after the input 'section' put something like this

data load;

infile 'path_file' <option>;

put

var1 ... varn

;

load_date=today();

run;

Work on the the datastep that i wrote because it's just an example

Re: Include date of file when importing

mjheever — Fri, 21 Feb 2014 09:33:25 GMT

Thank you for the reply Barnipaz .

But wouldn't this just give the present date ? I'm trying to create a variable that will show when this file (the excel file) was created, that is 2013/xx/xx.

Re: Include date of file when importing

Barnipaz — Fri, 21 Feb 2014 09:47:18 GMT

If you know the date, for example February 3rd 2013

load_date='03feb2013'd;

If you get it from some place, for example from the file name, get it and put in the expression. There are function the take the file name.

I'l give you a tip, a very important one.

Study all the function, format, informat and, all macrovariable created by default. With them you can do almost everything in SAS.

Re: Include date of file when importing

LinusH — Fri, 21 Feb 2014 10:55:33 GMT

FINFO() function will give you this information.

Re: Include date of file when importing

mjheever — Mon, 24 Feb 2014 07:57:18 GMT

Thank you for the help guys :smileygrin: :smileygrin: :smileygrin:.

Got the info of the file.