BookmarkSubscribeRSS Feed
DavidDemeyer
Calcite | Level 5

Hi everyone,


We have an Excel file that contains 90.000 rows when we import the file in SAS EG 5.1 we only have 2.175.

How can we solve this problem?


Thank you,

David


2 REPLIES 2
Doc_Duke
Rhodochrosite | Level 12

There are lots of possible reasons for this, as well as EG having multiple different ways to import Excel.  Some things to look at:

  • The generated SAS code and log -- it may provide a clue.
  • Did you specify a range?
  • Look at row 2175 in the data.  Is there an embedded CTRL-Z after the last field that came in? (you may need a hex editor to see it)

We might be able to help more with a copy of the log and screen shots from the import wizard.

Doc Muhlbaier

Duke

DavidDemeyer
Calcite | Level 5

Thanks a lot!

I checked the log and it had reached the _ERROR_-limit!

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 932 views
  • 3 likes
  • 2 in conversation