The "Table" drop-down list on the "OUTPUT DATA" tab in SAS® Studio might not display available tables when executing a LIBNAME in the CLEAR statement


In SAS Studio, an issue occurs where the Table drop-down list on the OUTPUT DATA tab does not display available tables. Below are two example scenarios.

Scenario 1: The Table Drop-Down List Correctly Displays the Available Tables

In SAS Studio, submit code similar to the following:

libname tmplib "c:\temp";
proc sort data=sashelp.class out=tmplib.class;
  by name;
run;
 
proc sort data=tmplib.class out=WORK.class;
  by descending name;
run;

When you submit the code, the OUTPUT DATA tab appears, and the Table drop-down list displays both TMPLIB.CLASS and WORK.CLASS, which is the expected behavior.

The OUTPUT DATA tab appears, and the Table drop-down list displays both TMPLIB.CLASS and WORK.CLASS.

Scenario 2: The Table Drop-Down List on the OUTPUT DATA Tab Does Not Display the Available Tables

In SAS Studio, add the LIBNAME CLEAR statement at the end of the following code and execute it:

libname tmplib "c:\temp";
proc sort data=sashelp.class out=tmplib.class;
 by name;
run;

proc sort data=tmplib.class out=WORK.class;
  by descending name;
 run;
libname tmplib CLEAR;

The Table drop-down list is grayed out, and you cannot select any tables. 

The Table drop-down list is grayed out, and you are unable to select any tables.