Hi,
I'm trying to import two SPSS data files into SAS, and I am getting a Read Access Violation and Write Access Violation when I do. I'm running SAS for Windows v9.4. Here is the code I am using:
libname huebhiv 'H:\Research\Huebner Paper HIV\';
run;
libname inlib spss 'H:\Research\Huebner Paper HIV\dash041818.sav';
proc convert spss=inlib out=huebhiv.dash050118;
run;
libname inlib spss 'H:\Research\Huebner Paper HIV\Oakland data_ONLY GOOD CASES.sav';
proc convert spss=inlib out=huebhiv.oakland050118;
run;
And when I run it, I get this error message:
7 proc convert spss=inlib out=huebhiv.dash050118;
8 run;
NOTE: Using the libref INLIB, which has already been assigned to the file H:\Research\Huebner Paper
HIV\dash041818.sav.
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
The SAS task name is [CONVERT]
ERROR: Read Access Violation CONVERT
Exception occurred at (045A0276)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
00000000045A0276 00000000277CC710 sasxkern:tkvercn1+0xBF236
000000000456DF2D 00000000277CC780 sasxkern:tkvercn1+0x8CEED
00000000090E3E76 00000000277CC788 sasspss:tkvercn1+0x2E36
00000000090E2D76 00000000277CD190 sasspss:tkvercn1+0x1D36
00000000090E17F1 00000000277CD200 sasspss:tkvercn1+0x7B1
00000000249285EB 00000000277CD208 sasyoio:tkvercn1+0x175AB
00000000249254F5 00000000277CF5A0 sasyoio:tkvercn1+0x144B5
00000000248F1805 00000000277CF5A8 sasconve:tkvercn1+0x7C5
0000000003348A2B 00000000277CFBF8 sashost:Main+0x10F0B
000000000334E66D 00000000277CFF50 sashost:Main+0x16B4D
00007FFD718F8364 00000000277CFF58 KERNEL32:BaseThreadInitThunk+0x14
00007FFD727370B1 00000000277CFF88 ntdll:RtlUserThreadStart+0x21
NOTE: The SAS System stopped processing this step because of errors.
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
The SAS task name is [CONVERT]
ERROR: Write Access Violation CONVERT
Exception occurred at (02A39C0B)
The SPSS file is not password-protected or anything like that, and when my mentor runs this code on his computer, it works fine for him. Could it be a version problem? Any thoughts or suggestions would be greatly appreciated. Thanks in advance for your help.
Andrew
Proc convert is expecting to convert a file created by the SPSS EXPORT command. Was your SAV file created as such? If the file is not in the format that the procedure expects then you will get unexpected results.
If libname inlib spss 'H:\Research\Huebner Paper HIV\dash041818.sav';
Then you might try to see if the LIBRARY inlib shows any members and copy them to bhe HUEBHIV directly. If the library association was accepted then you should be able to read the files.
With external files assigned as libraries it may be a good idea to clear the reference before attempting to reuse them as well such as:
libname inlib; libname inlib spss 'H:\Research\Huebner Paper HIV\Oakland data_ONLY GOOD CASES.sav';
Thanks for your response. I tried to run the code again with files that were created with the EXPORT command in SPSS, but I receive the same error message.
NOTE: Libref INLIB was successfully assigned as follows:
Engine: SPSS
Physical Name: H:\Research\Huebner Paper HIV\FINAL DASH_DATA ONLY GOOD CASES.por
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
The SAS task name is [CONVERT]
ERROR: Read Access Violation CONVERT
Exception occurred at (0459CBC9)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
000000000459CBC9 00000000300DABA0 sasxkern:tkvercn1+0xBBB89
00000000045306B4 00000000300DAC20 sasxkern:tkvercn1+0x4F674
0000000004542E4C 00000000300DADD0 sasxkern:tkvercn1+0x61E0C
00000000045420E1 00000000300DAEC0 sasxkern:tkvercn1+0x610A1
000000000453D521 00000000300DAF90 sasxkern:tkvercn1+0x5C4E1
0000000004750485 00000000300DAF98 sasyh:tkvercn1+0x2F445
000000000474F644 00000000300DBC00 sasyh:tkvercn1+0x2E604
000000000474BC3B 00000000300DBDD0 sasyh:tkvercn1+0x2ABFB
0000000004723278 00000000300DC570 sasyh:tkvercn1+0x2238
0000000024A6D65C 00000000300DC578 sasyoio:tkvercn1+0x1C61C
0000000024A654F5 00000000300DE910 sasyoio:tkvercn1+0x144B5
00000000049374B6 00000000300DE918 sasxshel:tkvercn1+0x46476
00000000049341A6 00000000300DEB20 sasxshel:tkvercn1+0x43166
000000000493AD93 00000000300DF480 sasxshel:tkvercn1+0x49D53
000000000493C31F 00000000300DF540 sasxshel:tkvercn1+0x4B2DF
0000000024A32362 00000000300DF548 sasconve:tkvercn1+0x1322
0000000024A310F4 00000000300DFBF0 sasconve:tkvercn1+0xB4
0000000003368A2B 00000000300DFBF8 sashost:Main+0x10F0B
000000000336E66D 00000000300DFF50 sashost:Main+0x16B4D
00007FF9F31E8364 00000000300DFF58 KERNEL32:BaseThreadInitThunk+0x14
00007FF9F3AF70B1 00000000300DFF88 ntdll:RtlUserThreadStart+0x21
NOTE: PROCEDURE CONVERT used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
Part of what is confusing is that the code seems to work on my mentor's version of SAS with the same data files, but not on mine. I also tried using different names for the two library files, but no help. Any other ideas for what to try would be greatly appreciated. Thanks again! Andrew
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.