topic Re: Excel Import in SAS EG in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Excel-Import-in-SAS-EG/m-p/110567#M9457 <HTML><HEAD></HEAD><BODY><P>There are lots of possible reasons for this, as well as EG having multiple different ways to import Excel.&nbsp; Some things to look at:</P><UL><LI>The generated SAS code and log -- it may provide a clue.</LI><LI>Did you specify a range?</LI><LI>Look at row 2175 in the data.&nbsp; Is there an embedded CTRL-Z after the last field that came in? (you may need a hex editor to see it)</LI></UL><P></P><P>We might be able to help more with a copy of the log and screen shots from the import wizard.</P><P></P><P>Doc Muhlbaier</P><P>Duke</P></BODY></HTML> Fri, 15 Feb 2013 19:11:53 GMT Doc_Duke 2013-02-15T19:11:53Z Excel Import in SAS EG https://communities.sas.com/t5/SAS-Enterprise-Guide/Excel-Import-in-SAS-EG/m-p/110566#M9456 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #333333; font-family: Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Hi everyone, <BR /></SPAN></P><P><SPAN style="color: #333333; font-family: Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><BR /></SPAN></P><P><SPAN style="color: #333333; font-family: Arial, sans-serif; font-size: 14px; background-color: #ffffff;">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.</SPAN></P><P><SPAN style="color: #333333; font-family: Arial, sans-serif; font-size: 14px; background-color: #ffffff;">How can we solve this problem?</SPAN></P><P><SPAN style="color: #333333; font-family: Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><BR /></SPAN></P><P><SPAN style="color: #333333; font-family: Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Thank you,</SPAN></P><P><SPAN style="color: #333333; font-family: Arial, sans-serif; font-size: 14px; background-color: #ffffff;">David<BR /></SPAN></P><P><SPAN style="color: #333333; font-family: Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><BR /></SPAN></P></BODY></HTML> Fri, 15 Feb 2013 14:48:33 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Excel-Import-in-SAS-EG/m-p/110566#M9456 DavidDemeyer 2013-02-15T14:48:33Z Re: Excel Import in SAS EG https://communities.sas.com/t5/SAS-Enterprise-Guide/Excel-Import-in-SAS-EG/m-p/110567#M9457 <HTML><HEAD></HEAD><BODY><P>There are lots of possible reasons for this, as well as EG having multiple different ways to import Excel.&nbsp; Some things to look at:</P><UL><LI>The generated SAS code and log -- it may provide a clue.</LI><LI>Did you specify a range?</LI><LI>Look at row 2175 in the data.&nbsp; Is there an embedded CTRL-Z after the last field that came in? (you may need a hex editor to see it)</LI></UL><P></P><P>We might be able to help more with a copy of the log and screen shots from the import wizard.</P><P></P><P>Doc Muhlbaier</P><P>Duke</P></BODY></HTML> Fri, 15 Feb 2013 19:11:53 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Excel-Import-in-SAS-EG/m-p/110567#M9457 Doc_Duke 2013-02-15T19:11:53Z Re: Excel Import in SAS EG https://communities.sas.com/t5/SAS-Enterprise-Guide/Excel-Import-in-SAS-EG/m-p/110568#M9458 <HTML><HEAD></HEAD><BODY><P>Thanks a lot! </P><P></P><P>I checked the log and it had reached the _ERROR_-limit!</P></BODY></HTML> Tue, 19 Feb 2013 17:01:49 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Excel-Import-in-SAS-EG/m-p/110568#M9458 DavidDemeyer 2013-02-19T17:01:49Z