The error "The table could not be opened or may have been deleted" might be displayed on the "Output Data" tab in SAS® Studio


In SAS® Studio (Enterprise) release 5.2.1 on SAS® Viya® 3.5, the following error might occur when viewing results on the Output Data tab:

"Unable to open table "WORK._ZSQL0". The table could not be opened or may have been deleted."

This error might occur when you execute the SUMMARY procedure with an output statement where the source table is a database table.

Here is an example:

libname dbms <ANY VALID DBMS LIBNAME>;

data dbms.class;
 set sashelp.class;
run ; 

proc summary data=dbms.class ;
    class sex;
    var age;
    output out=work.output_table sum=TotalNumeric1;
quit;

This behavior is specific to SYSVLONG4=V.03.05M0P10182024.

To check your SAS Viya version, submit the following code:

%put &sysvlong4;

Workaround

To work around this issue, view the output table under the WORK library in the library navigation panel.