topic Re: ERROR: Read Access Violation IMPORT in SAS Procedures

ERROR: Read Access Violation IMPORT

TheBlackBishop — Fri, 09 Mar 2018 10:18:02 GMT

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.

Re: ERROR: Read Access Violation IMPORT

RW9 — Fri, 09 Mar 2018 10:48:47 GMT

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.

Re: ERROR: Read Access Violation IMPORT

TheBlackBishop — Fri, 09 Mar 2018 11:15:17 GMT

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

Re: ERROR: Read Access Violation IMPORT

RW9 — Fri, 09 Mar 2018 11:45:27 GMT

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.

Re: ERROR: Read Access Violation IMPORT

TheBlackBishop — Fri, 09 Mar 2018 11:48:30 GMT

Thank you