When you open a SAS SPDS view that contains no records in SAS Enterprise Guide, the following error message appears:

ERROR: Cannot open data set 'XXX"

ERROR: Current access pattern does not support random access.

 

Steps to Reproduce

1. Use a SPDS library with the SASSPDS engine, such as the following LIBNAME statement: 

libname spdslib1 SASSPDS ....;

2. Create an empty table in that SPDS library similar to the following:

data spdslib1.empty_ds;
    set sashelp.class;
    stop;
run;

3. Create a view from that empty table in that SPDS library:

proc sql; 
    create view spdslib1.v_empty_ds as 
    select * 
from spdslib1.empty_ds; 
quit; run;

4. Open the view "v_empty_ds" in Enterprise Guide and the following error appears:

ERROR: Cannot open data set "V_EMPTY_DS"

ERROR: Current access pattern does not support random access.

 

Further Observations

The empty SPDS table "empty_ds" can be opened without any issue in SAS Enterprise Guide.

The empty SPDS view "v_empty_ds" can be opened in SAS^® Foundation or SAS^® Data Integration Studio.