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.
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.
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.
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
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.
Thank you
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.
Ready to level-up your skills? Choose your own adventure.