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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.