where SQL is the libref for a remote SAS library accessed through a SAS/CONNECT or a SAS/SHARE server, each row of the table EMPLOYEE must be returned to your local SAS session for the summary ...

SAS/ACCESS views and DATA step views are similar to PROC SQL views in that they are both data definitions of member type VIEW. SAS/ACCESS views describe data in DBMS tables from other software vendors ...