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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.