topic How to read date from a txt file? in SAS Programming

How to read date from a txt file?

KrishnaChandra — Thu, 10 Jul 2014 06:56:58 GMT

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;

Re: How to read date from a txt file?

Scott_Mitchell — Thu, 10 Jul 2014 07:06:28 GMT

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;

Re: How to read date from a txt file?

KrishnaChandra — Thu, 10 Jul 2014 07:19:04 GMT

Got output.Thank you so much for your valuable information.Am a beginner in SAS

Re: How to read date from a txt file?

Scott_Mitchell — Thu, 10 Jul 2014 07:35:28 GMT

We all have to start somewhere. We are here to help when we can.

Re: How to read date from a txt file?

cov_derek — Thu, 24 Jul 2014 17:01:22 GMT

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