12-04-2017 09:56 AM
NOTE: SGIO processing active for file INDATA.DEMOGRAPHIC.DATA.
ERROR: An exception has been encountered.
ERROR: The SAS task name is [SGIOREAD]
ERROR: Write Access Violation SGIOREAD
ERROR: Exception occurred at (02DBA231)
ERROR: Task Traceback
ERROR: Address Frame (DBGHELP API Version 4.0 rev 5)
ERROR: 0000000002DBA231 0000000003E0FBF0 sashost:Main+0xA2711
ERROR: 0000000002D289DB 0000000003E0FF20 sashost:Main+0x10EBB
ERROR: 0000000002D2E61D 0000000003E0FF50 sashost:Main+0x16AFD
ERROR: 00007FF8C74613D2 0000000003E0FF58 KERNEL32:BaseThreadInitThunk+0x22
ERROR: 00007FF8C7D154F4 0000000003E0FF88 ntdll:RtlUserThreadStart+0x34
=========== Code fragment
data _demogs (sgio=no);
set indata.demographic (keep=patid birth_date sex hispanic race source);
where source not in ('X' 'Y' 'Z');
if missing(Patid)=0 and missing(Birth_date)=0 then both=1;
if missing(Birth_date)=0 then do;
if month(Birth_date) = 2 and day(Birth_date)=29 then minagedate=minagedate+1;
if month(Birth_date) = 2 and day(Birth_date)=29 then maxagedate=maxagedate+1;
format minagedate maxagedate date9.;
12-04-2017 10:27 AM
You must have the option setup then, autoexcec or something like that. What software are you using? Can you see what options are set when you open SAS? Also, if you have write access, that sounds like you don't have access to something, either the area where the file is located, or to your temporary workspace. Do other datasets work (i.e. write a dataset from sashelp to your work).
12-04-2017 10:31 AM
-SGIO option is set in the global SAS config file (SAS version 9.4)
Removing the SGIO option from the global config and restarting SAS fixes the issue, but we wanted to take advantage of the faster data processing using SGIO.
12-04-2017 10:39 AM
To be honest I have never used or even heard of that option. I assume your using Windows and the file is on Windows? That was the only requirement I could find on this topic. Otherwise, contact your SAS support contact, maybe you need something else installed.