Note that you can specify a libref that references DBMS data in the DATA= option. libname mydb2lib db2 ssid=db2; proc print data=mydb2lib.staff (keep=lname fname hphone state); where state = 'NJ'; ...
The examples in this section illustrate creating a permanent access descriptor named MYLIB.CUSTS and two view descriptors named VLIB.USACUSTS and VLIB.CUSTADD. Begin by using the SAS LIBNAME statement ...