PROC FEDSQL produces the following error when you try to query a Sashelp library or other concatenated libref:

To use the Sashelp.Class data set, for example, you would need to use a separate LIBNAME statement that points to the individual directory that contains that file. 

To find the subdirectories in the concatenated libref, run the following code: 

Click the Full Code tab to see sample code to find and isolate a value that you need from the concatenated path.

Operating System and Release Information

/*This FEDSQL step produces the error.*/ 
proc fedsql; 
create table work.test as
select * from sashelp.class; 
run; 

/*This list shows the subdirectories in the conconcatenated libref.*/ 
libname sashelp list; 

/*The path for a new LIBNAME statement is found from the list results.*/ 
libname test1 base '/opt/sas/spre/home/SASFoundation/sashelp'; 


/*Use PROC CONTENTS to find the directory that contains the desired file.*/ 
proc contents data=test1.class; 
run; 

/*Now, the FEDSQL step works because it is pointing to the new libref and not Sashelp.*/ 
proc fedsql; 
create table work.test as 
select * from test1.class; 
quit;