Hi Everyone,
When I export 2 SAS datasets to Excel, the first one goes fine, then I received the following error when the 2nd file is being exported.
The log below I got from my SAS running in batch.
Recently, when I manually run the export, sometime SAS automatically shutdown. In these instance, I dont have a log file to see what is going on.
Now I have the log. Can you please review and see what can I do to fix?
Thanks,
HHC
proc export data=m44_UP
outfile="C:\Users\OneDrive\........\file1_UP_&today..xlsx"
replace;
run;
proc export data=m44_DOWN
outfile="C:\Users\OneDrive \.........\file1_DOWN_&today..xlsx"
replace;
run;
NOTE: File "C:\Users\OneDrive\.......\file1_UP_20220414.xlsx" will be created if the export process succeeds.
NOTE: "M44_UP" range/sheet was successfully created.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.33 seconds
cpu time 0.20 seconds
NOTE: File "C:\Users\OneDrive\......\file2_DOWN_20220414.xlsx" will be created if the export process succeeds.
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
The SAS task name is [EXPORT]
ERROR: Read Access Violation EXPORT
Exception occurred at (0795C006)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
000000000795C006 00000000096CB910 sasjet:tkvercn1+0xAFC6
0000000007D5DFF8 00000000096CB918 sasiojet:tkvercn1+0xCFB8
0000000007DF3828 00000000096CB9B8 sasxdbi:tkvercn1+0x427E8
0000000007DC77A1 00000000096CBA90 sasxdbi:tkvercn1+0x16761
0000000004919F84 00000000096CBA98 sasyh:tkvercn1+0x18F44
0000000004BB83C9 00000000096CBC18 sasxshel:tkvercn1+0x27389
0000000004B9344E 00000000096CC0C0 sasxshel:tkvercn1+0x240E
0000000004B919F5 00000000096CC150 sasxshel:tkvercn1+0x9B5
0000000004BBC332 00000000096CC2D0 sasxshel:tkvercn1+0x2B2F2
0000000004BE81C2 00000000096CC630 sasxshel:tkvercn1+0x57182
0000000004BEBDC4 00000000096CC720 sasxshel:tkvercn1+0x5AD84
116 The SAS System 17:12 Thursday, April 14, 2022
0000000004BE5015 00000000096CC7C0 sasxshel:tkvercn1+0x53FD5
0000000007771877 00000000096CC7C8 sasimdts:tkvercn1+0x837
000000000774372A 00000000096CC8C8 sasimode:tkvercn1+0x26EA
0000000005584497 00000000096CE9C8 sasimctr:tkvercn1+0x3457
00000000055817FB 00000000096CF820 sasimctr:tkvercn1+0x7BB
00000000055612B0 00000000096CF828 sasexpor:tkvercn1+0x270
000000000349A066 00000000096CF9B8 sashost:Main+0x11BA6
00000000034A011D 00000000096CFD20 sashost:Main+0x17C5D
00007FF842F97034 00000000096CFD28 KERNEL32:BaseThreadInitThunk+0x14
00007FF844BA2651 00000000096CFD58 ntdll:RtlUserThreadStart+0x21
SAS WTABORT (EXPORT) The SAS System has detected an abort condition. An Exception occurred
during wthtrm().
Please Contact Technical Support.
Tasks
[MAIN ] [WAITING ] pri[ 5] reb[03366E40] WC[0] WN[1]
[IDLETASK] [READY ] pri[ 9] reb[03366E40]
[EVENTTSK] [WAITING ] pri[ 0] reb[03366E40] WC[0] WN[1]
[sasxkern] [WAITING ] pri[ 3] reb[03366E40] WC[0] WN[1]
[SGIOREAD] [WAITING ] pri[ 3] reb[03366E40] WC[0] WN[1]
[SGIOWRIT] [WAITING ] pri[ 3] reb[03366E40] WC[0] WN[1]
[Session ] [WAITING ] pri[ 3] reb[04C77FA0] WC[0] WN[1]
[TKSRV ] [WAITING ] pri[ 3] reb[04C78620] WC[0] WN[1]
[Program ] [WAITING ] pri[ 7] reb[04C79140] WC[0] WN[1]
[SASODR ] [WAITING ] pri[ 3] reb[0816F2C0] WC[0] WN[1]
[EXPORT ] [RUNNING ] pri[ 7] reb[0816DD40]
Traceback
SASTBTraceBackCtx has been called with a
string ("vacrash") instead of a CONTEXT pointer.
Address Frame (DBGHELP API Version 4.0 rev 5)
00007FF842354F69 00000000096C9760 KERNELBASE:RaiseException+0x69
0000000010055F3B 00000000096C9768 tkmk:tkBoot+0x541EB
0000000010055D09 00000000096C9CB0 tkmk:tkBoot+0x53FB9
000000001004A15A 00000000096C9D00 tkmk:tkBoot+0x4840A
00000000034912D9 00000000096C9D08 sashost:Main+0x8E19
00000000034821C4 00000000096C9DB0 sashost:rtmdoit+0x234
0000000003495F8F 00000000096C9F30 sashost:Main+0xDACF
0000000003499A10 00000000096CA0E0 sashost:Main+0x11550
000000000349FEAA 00000000096CA6B0 sashost:Main+0x179EA
000000000349F6B9 00000000096CA9D0 sashost:Main+0x171F9
00000000034A0140 00000000096CAA00 sashost:Main+0x17C80
000000000360351F 00000000096CAA70 sashost:tkStartSas+0xB67F
00007FF844BF20CF 00000000096CAA78 ntdll:_chkstk+0x11F
00007FF844BA1454 00000000096CB1B0 ntdll:RtlRaiseException+0x434
00007FF844BF0BFE 00000000096CB8D0 ntdll:KiUserExceptionDispatcher+0x2E
000000000795C006 00000000096CB8D8 sasjet:tkvercn1+0xAFC6
0000000007D5DFF8 00000000096CB918 sasiojet:tkvercn1+0xCFB8
0000000007DF3828 00000000096CB9B8 sasxdbi:tkvercn1+0x427E8
117 The SAS System 17:12 Thursday, April 14, 2022
0000000007DC77A1 00000000096CBA90 sasxdbi:tkvercn1+0x16761
0000000004919F84 00000000096CBA98 sasyh:tkvercn1+0x18F44
0000000004BB83C9 00000000096CBC18 sasxshel:tkvercn1+0x27389
0000000004B9344E 00000000096CC0C0 sasxshel:tkvercn1+0x240E
0000000004B919F5 00000000096CC150 sasxshel:tkvercn1+0x9B5
0000000004BBC332 00000000096CC2D0 sasxshel:tkvercn1+0x2B2F2
0000000004BE81C2 00000000096CC630 sasxshel:tkvercn1+0x57182
0000000004BEBDC4 00000000096CC720 sasxshel:tkvercn1+0x5AD84
0000000004BE5015 00000000096CC7C0 sasxshel:tkvercn1+0x53FD5
0000000007771877 00000000096CC7C8 sasimdts:tkvercn1+0x837
000000000774372A 00000000096CC8C8 sasimode:tkvercn1+0x26EA
0000000005584497 00000000096CE9C8 sasimctr:tkvercn1+0x3457
00000000055817FB 00000000096CF820 sasimctr:tkvercn1+0x7BB
00000000055612B0 00000000096CF828 sasexpor:tkvercn1+0x270
000000000349A066 00000000096CFCF0 sashost:Main+0x11BA6
00000000034A011D 00000000096CFD20 sashost:Main+0x17C5D
00007FF842F97034 00000000096CFD28 KERNEL32:BaseThreadInitThunk+0x14
00007FF844BA2651 00000000096CFDD0 ntdll:RtlUserThreadStart+0x21
ERROR: User asked for termination
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.28 seconds
cpu time 0.28 seconds
ERROR: Errors printed on pages 115,116,117.
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 9:01.08
cpu time 8:25.23
