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!
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
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.
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.
FINFO() function will give you this information.
Thank you for the help guys :smileygrin: :smileygrin: :smileygrin:.
Got the info of the file.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.