Page tree



Back to Knowledge Base

How To Use PROC FEDSQL

Purpose 

To help users optimize a FEDSQL session. 

Step-by-Step

Step One-

To access the relevant CAS session, particularly any datasets that might have been promoted in the local CAS session, like this: 

PROC FEDSQL sessref = mysess;

Step Two- 

Unlike PROC SQL, users must specify actual CASLIB rather than LIBREF to it. If users are choose CASUSER the following must be used:

CREATE TABLE CASUSER.TEST

If users are using CASLIB with characters like hyphens and spaces, they should put CASLIB name inside the quotes like: 

"MY CASLIB".TEST

  • No labels