BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
TheBlackBishop
Calcite | Level 5

I am using SAS as a client through a school as a student and i am trying to import an xslx file but i get an error code to contact technical support

 

SA import command:

 

proc import out = stroke.s1
datafile= '\\tsclient\C\Users\Desktop\StrokeData\StrokeData.xlsx'
dbms= xlsx replace;
sheet="three";
getnames=YES;
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]
ERROR: Read Access Violation IMPORT
Exception occurred at (068B3F86)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
00000000068B3F86 000000002779C240 sasimxlx:tkvercn1+0x12F46
00000000068AFF2F 00000000277AE530 sasimxlx:tkvercn1+0xEEEF
00000000068A681A 00000000277AE580 sasimxlx:tkvercn1+0x57DA
00000000068A17AD 00000000277AE5B0 sasimxlx:tkvercn1+0x76D
0000000006872F74 00000000277AE5B8 sasimctr:tkvercn1+0x1F34
0000000006871784 00000000277AF680 sasimctr:tkvercn1+0x744
000000000685126D 00000000277AF688 sasimpor:tkvercn1+0x22D
0000000002F483AB 00000000277AFBF8 sashost:Main+0x10F1B
0000000002F4DFDD 00000000277AFF50 sashost:Main+0x16B4D
00007FFC493E8364 00000000277AFF58 KERNEL32:BaseThreadInitThunk+0x14
00007FFC497B7091 00000000277AFF88 ntdll:RtlUserThreadStart+0x21

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 6.31 seconds
cpu time 0.04 seconds

 

Thank you. Any help is appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Perhaps your missing a vpn connection to the system or something like that.  From what you say - code runs on school machine, but not on your machine, then the only conclusion is that the school machine has access to that area, and your machine doesn't.  Contact the school, you may need to vpn into their system to be able to use it.  Much the same as if I want to use our old SAS system, I need to vpn into work, then use it there.

View solution in original post

4 REPLIES 4
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Well, you don't state what particular branch of SAS software you are using, for example Enterprise Guide, or university Edition.  That being said this path:

 '\\tsclient\C\Users\Desktop\StrokeData\StrokeData.xlsx'

 

Is wrong on any system.  You are mixing a local windows drive - e.g. C\Users\Desktop\StrokeData - with either a network location or a location on a virtual image (if your using SAS University Edition then that is installed on a virtual image which is like a partition of your machine for a different computer altogether).  If you using UE, then you need to copy the file to the virtual machine and then specify the filename as something like:

//MyFolders/StrokeData.xlsx

 

If you using something else, then you need to check what the path to the file is in relation to the system, not your machine, e.g. I have SAS installed on a network drive, then I need to copy the file there and then reference the network drive:

//NetworkDrive/Location/Directory/StrokeData.xlsx

 

I would check with your school or documentation as this is a fundamental part of the learning exercise so should be in the training quite early on.

 

TheBlackBishop
Calcite | Level 5

Thank you for your response.

 

Its SAS 9.4 and it is on my school network.

'tsclient 'is the network drive and the location follows. I have used that same path to create the libname. The last time i did this on my computer, i had similar issues and then i went on school computers to import the file before continuing on my computer.

 

Also i checked the xlsx file for any encoding and i unblocked security features.

 

Thanks

RW9
Diamond | Level 26 RW9
Diamond | Level 26

Perhaps your missing a vpn connection to the system or something like that.  From what you say - code runs on school machine, but not on your machine, then the only conclusion is that the school machine has access to that area, and your machine doesn't.  Contact the school, you may need to vpn into their system to be able to use it.  Much the same as if I want to use our old SAS system, I need to vpn into work, then use it there.

TheBlackBishop
Calcite | Level 5

Thank you

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 4 replies
  • 9705 views
  • 0 likes
  • 2 in conversation