BookmarkSubscribeRSS Feed
tianerhu
Pyrite | Level 9
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?

D.png

 

 

7 REPLIES 7
tianerhu
Pyrite | Level 9

the result is the following:

E.png

tianerhu
Pyrite | Level 9

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

E.png

Tom
Super User Tom
Super User

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?

Jagadishkatam
Amethyst | Level 16

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;
Thanks,
Jag
tianerhu
Pyrite | Level 9
Thank you .
Kurt_Bremser
Super User

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.

tianerhu
Pyrite | Level 9
Thank you for your reply.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 7 replies
  • 930 views
  • 0 likes
  • 4 in conversation