Desktop productivity for business analysts and programmers

Excel Import in SAS EG

Occasional Contributor
Posts: 12

Excel Import in SAS EG

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,


Trusted Advisor
Posts: 2,127

Re: Excel Import in SAS EG

Posted in reply to DavidDemeyer

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


Occasional Contributor
Posts: 12

Re: Excel Import in SAS EG

Thanks a lot!

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

Ask a Question
Discussion stats
  • 2 replies
  • 2 in conversation