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;
minagedate=intnx("year",Birth_date,18,"SAMEDAY");
if month(Birth_date) = 2 and day(Birth_date)=29 then minagedate=minagedate+1;
maxagedate=intnx("year",Birth_date,85,"SAMEDAY");
if month(Birth_date) = 2 and day(Birth_date)=29 then maxagedate=maxagedate+1;
end;
format minagedate maxagedate date9.;
run;
Take this:
(sgio=no)
Out of the code, then run it. It is masking any real errors. Re-run then post the log of what happens.
Removing sgio=no produces the same error
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).
-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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: