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

Error during proc import

Reply
New Contributor
Posts: 4

Error during proc import

Dear All,

 

I am getting following error while importing an xls file. I did not face this issue earlier.

 

proc import datafile="/folders/myfolders/QRAData/Loan.xls" out=qra.loan replace dbms=xls;
63 run;
 
 
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
 
The SAS task name is [IMPORT (]
Segmentation Violation
 
Traceback of the Exception:
 
/opt/sasinside/SASHome/SASFoundation/9.4/sasexe/sas(+0x15cfde) [0x7f2110840fde]
/opt/sasinside/SASHome/SASFoundation/9.4/sasexe/sas(+0x4cb7b) [0x7f2110730b7b]
/opt/sasinside/SASHome/SASFoundation/9.4/sasexe/tkmk.so(bkt_signal_handler+0x144) [0x7f210f0fb404]
/lib64/libpthread.so.0(+0xf7e0) [0x7f21102b47e0]
/opt/sasinside/SASHome/SASFoundation/9.4/sasexe/sasimxcl(grab_ole_object+0x2db) [0x7f20a4e281fb]
/opt/sasinside/SASHome/SASFoundation/9.4/sasexe/sasimxcl(+0x129dc) [0x7f20a4e1b9dc]
/opt/sasinside/SASHome/SASFoundation/9.4/sasexe/sasimxcl(dbmscopy_read_header+0x94) [0x7f20a4e15594]
/opt/sasinside/SASHome/SASFoundation/9.4/sasexe/sasimxcl(getvars+0xa) [0x7f20a4e1064a]
/opt/sasinside/SASHome/SASFoundation/9.4/sasexe/sasimctr(cpfdata+0x7c) [0x7f20a525dffc]
/opt/sasinside/SASHome/SASFoundation/9.4/sasexe/sasimctr(import+0x609) [0x7f20a525da79]
/opt/sasinside/SASHome/SASFoundation/9.4/sasexe/sasimctr(parsexe+0x24b) [0x7f20a525cadb]
/opt/sasinside/SASHome/SASFoundation/9.4/sasexe/sasimpor(sasimpor+0x1a8) [0x7f20a5477d28]
/opt/sasinside/SASHome/SASFoundation/9.4/sasexe/sas(vvtentr+0x13d) [0x7f211073071d]
/lib64/libpthread.so.0(+0x7aa1) [0x7f21102acaa1]
/lib64/libc.so.6(clone+0x6d) [0x7f210f93aaad]
 
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.49 seconds
cpu time 0.11 seconds
 
64
65
66 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
79
Super User
Posts: 17,784

Re: Error during proc import

Have you restarted your VM and browser?

New Contributor
Posts: 4

Re: Error during proc import

Hi,

 

I have tried all the options including restarting VM but later found that there were 2 blank rows in the csv file which caused the issue. But i was wondering if the error message in the log is informative enough to fix the issues.

 

 

Super User
Posts: 17,784

Re: Error during proc import

You say CSV file but your code was for an XLS file? If you can replicate the issue successfully report it to SAS Tech Support, via support@sas.com

Super User
Posts: 10,483

Re: Error during proc import

If you are reading CSV then you should not have dbms=xls

With dbms=CSV you can specify the first data row to skip the blank lines (one you know they are there) using the DATAROW option.

 

The type of error you posted is one that sometimes indicates a bug in SAS but usually, at least in my experience, comes from using wrong instructions on a procedure, for instance telling SAS to read a file as one format when it is actually in a different format.

Computers are stupid, they do what we tell them. If we tell them do try to do the wrong thing then something happens, hopefully only an error message. Otherwise we have Skynet launching ICBMs... Smiley Wink

Ask a Question
Discussion stats
  • 4 replies
  • 284 views
  • 0 likes
  • 3 in conversation