The CONNECT statement establishes a connection with the DBMS. You establish a connection to send DBMS-specific SQL statements to the DBMS or to retrieve DBMS data. The connection remains in effect ...

For example, proc sql; connect to remote (server=sunserv dbms=oracle); execute (delete from parts.inventory where part_bin_number='093A6') by remote; sends the SQL DELETE statement through the SAS ...