topic Re: Reading text file is not reading correctly. in SAS Procedures

Reading text file is not reading correctly.

ER1C — Mon, 06 Jul 2020 20:31:53 GMT

Hello everyone, I'm a beginner at SAS, so I am having trouble reading a text file. I dont know how to read this text file because it keeps skipping over the height column in my out put. the code and output are below. any advice? thanks in advance!

The Text files looks like this :

J,08,2,1,02/08/1998,74,280,1.9,4.3,6

J,11,1, ,12/14/1997,66,169,3.5,3.3,5.2

R,16,1,1,12/27/1997,70,233,1.6,1.6

R,09,2,2,12/27/1997,74,387,4.4,1.5,2

J,06,1,2,01/03/1998,64,210,4,4.2,4.4

J,10,1,2,01/03/1998,68,258,10.3,9,5.2

R,15,1,2, ,70,172,6.3

J,07,2,3,01/10/1998,74,177,2.3,3.4,4.5

J,09,2,3,01/11/1998,72,185,1.4,1.4,1.4

J,12,2,3,01/17/1998,76,358,3.9,5,7.6

R,08,2,3,01/24/1998,72,386,4,5.1

R,10,2,3,02/21/1998,62,152,6

J,14,1,3,01/04/1998,69,195,7.8,1.3,5.6

R,24,1,3,02/07/1998,67,212,1.8,2.3,2.3

J,13,1,4,01/31/1998,63,204,4.7,7.3,1

The Code looks like this:

data study;
	infile "...." TRUNCOVER;
	input
Site :$1. Pt :$2. Sex :8. Race :8. Dosedate mmddyy10. Height :8. Weight :8. Result1 :8. Result2 :8. Result3 :8.;
format Dosedate mmddyy10.;
Run;

Here is the output:

anyone know why height isnt being read?

Re: Reading text file is not reading correctly.

Reeza — Mon, 06 Jul 2020 19:40:46 GMT

You'll need to post a few lines of the text file. Is it a delimited or a fixed width file?

Re: Reading text file is not reading correctly.

ER1C — Mon, 06 Jul 2020 20:32:40 GMT

post edited!

Re: Reading text file is not reading correctly.

ER1C — Mon, 06 Jul 2020 19:54:58 GMT

J,08,2,1,02/08/1998,74,280,1.9,4.3,6

J,11,1, ,12/14/1997,66,169,3.5,3.3,5.2

R,16,1,1,12/27/1997,70,233,1.6,1.6

R,09,2,2,12/27/1997,74,387,4.4,1.5,2

J,06,1,2,01/03/1998,64,210,4,4.2,4.4

J,10,1,2,01/03/1998,68,258,10.3,9,5.2

R,15,1,2, ,70,172,6.3

J,07,2,3,01/10/1998,74,177,2.3,3.4,4.5

J,09,2,3,01/11/1998,72,185,1.4,1.4,1.4

J,12,2,3,01/17/1998,76,358,3.9,5,7.6

R,08,2,3,01/24/1998,72,386,4,5.1

R,10,2,3,02/21/1998,62,152,6

J,14,1,3,01/04/1998,69,195,7.8,1.3,5.6

R,24,1,3,02/07/1998,67,212,1.8,2.3,2.3

J,13,1,4,01/31/1998,63,204,4.7,7.3,1

Re: Reading text file is not reading correctly.

ketpt42 — Mon, 06 Jul 2020 20:41:48 GMT

This is working for me:

data study;
    infile "/folders/myfolders/data.txt"  dsd missover;
    input
Site :$1. Pt :$2. Sex :8. Race :8. Dosedate :mmddyy10. Height :8. Weight :8. Result1 :8. Result2 :8. Result3 :8.;
format Dosedate mmddyy10.;

Run;

Mainly I added a colon after Dosedate on your input statement.

Re: Reading text file is not reading correctly.

ER1C — Mon, 06 Jul 2020 20:44:57 GMT

wow, thank you so much!