Learning SAS? Welcome to the exclusive online community for all SAS learners.

My SAS table made from CSV file is cutting off rows of data. How do I fix this?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

My SAS table made from CSV file is cutting off rows of data. How do I fix this?

I am just beginning to learn how to use SAS University Edition and I imported a CSV file that had somewhere around 1800 rows of data, and made a SAS table.  However, when I looked at the output, the table only had 100 rows of data.  How can I go about fixing this problem?  Any help would be greatly appreciated.

 

Code:

data LDLTable;

       infile '/folders/myfolders/Michael/LDL Numbers.csv' dlm=',' firstobs=2;

       input B1 B2 B3 B4 B5;

run;


Accepted Solutions
Solution
‎01-25-2017 04:22 PM
Super User
Posts: 19,772

Re: My SAS table made from CSV file is cutting off rows of data. How do I fix this?

The default display is only 100 rows, click the arrows at the top right hand corner to see all observations.

What does the log say, please post the code & log if you're having issues.

 

View solution in original post


All Replies
Solution
‎01-25-2017 04:22 PM
Super User
Posts: 19,772

Re: My SAS table made from CSV file is cutting off rows of data. How do I fix this?

The default display is only 100 rows, click the arrows at the top right hand corner to see all observations.

What does the log say, please post the code & log if you're having issues.

 

Occasional Contributor
Posts: 10

Re: My SAS table made from CSV file is cutting off rows of data. How do I fix this?

Thanks. I didn't realize that. All the data is there, the log said that it read all 1878 records.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 267 views
  • 0 likes
  • 2 in conversation