topic Re: why three observations disappear? in SAS Procedures

why three observations disappear?

tianerhu — Sat, 25 Apr 2020 23:55:55 GMT

data recovery;
infile 'C:\Users\liaodong\Documents\My SAS Files\9.4\bio\project\recovery.txt' dlm='09'x firstobs=2;
input ID treatment age duration score1 score2 score3 score4;
run;
title 1 row;
proc print data = recovery ;
run;


/*the following picture is my data set, the 38-41 rows disappear after running the code above?
why?

Re: why three observations disappear?

tianerhu — Sun, 26 Apr 2020 00:00:42 GMT

the result is the following:

Re: why three observations disappear?

tianerhu — Sun, 26 Apr 2020 00:03:08 GMT

the result is the following: (row 38-41 disappear, why?)

Re: why three observations disappear?

Tom — Sun, 26 Apr 2020 00:26:17 GMT

What does the SAS log say?

Why do you post photographs of text? Isn't it harder to to create and post the photos than it would be to just copy the actual text and paste it?

Re: why three observations disappear?

Jagadishkatam — Sun, 26 Apr 2020 06:36:08 GMT

Not sure of the reason why they are missing, however you may try the option TRUNCOVER and run the code

data recovery;
infile 'C:\Users\liaodong\Documents\My SAS Files\9.4\bio\project\recovery.txt' dlm='09'x firstobs=2 TRUNCOVER;
input ID treatment age duration score1 score2 score3 score4;
run;
title 1 row;
proc print data = recovery ;
run;

Re: why three observations disappear?

Kurt_Bremser — Sun, 26 Apr 2020 07:05:13 GMT

Attach the file to your next post, and post the log from the step using the </> button.

For the future: do NOT post data in pictures. Copy/paste text data into a window opened with the </> button; post SAS datasets as data steps with datalines. Use the "little running man" for code.

Re: why three observations disappear?

tianerhu — Wed, 06 May 2020 01:09:28 GMT

Thank you .

Re: why three observations disappear?

tianerhu — Wed, 06 May 2020 01:10:24 GMT

Thank you for your reply.