How to read date from a txt file?
am trying to read this way.But saw some errors
File4.txt
1 arun joy 12/6/1989
data g;
infile 'H:\SasWorkSpace\File4.txt';
input no @2 name $9. @12 dob ddmmyy10.;
run;
Your informat was incorrect. Try this.
data g;
infile 'e:\test\File4.txt';
input no @2 name $9. @12 dob ddmmyy9.;
format dob date9.;
run;
Your informat was incorrect. Try this.
data g;
infile 'e:\test\File4.txt';
input no @2 name $9. @12 dob ddmmyy9.;
format dob date9.;
run;
Got output.Thank you so much for your valuable information.Am a beginner in SAS
We all have to start somewhere. We are here to help when we can.
Krishna,
I would use a colon (:) modifier on the ddmmyy10. informat instead of changing the informat length.
data g;
infile 'e:\test\File4.txt';
format dob date9.;
run;
The colon basically allows SAS to stop processing as soon as it hits the space in position 10, and translate the string of 9 characters instead of expecting all 10. The problem with the simple solution of changing the format length is that if you have a date longer than that like 14/10/2014, only reading 9 characters will give you incorrect results.
Hope this helps your understanding,
Derek
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.