Include date of file when importing

[mjheever]

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!

[Barnipaz]

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

[mjheever]

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.

[Barnipaz]

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.

[LinusH · Accepted solution]

FINFO() function will give you this information.

[mjheever]

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

Got the info of the file.