Specifies criteria for subsetting and ordering DBMS data.
Valid in: | DATA and PROC steps |
Supports: | All |
proc sql; create view smithnames as select lastname from myoralib.employees (dbcondition="where soundex(lastname) = soundex('SMYTHE')" ) using libname myoralib oracle user=testuser pw=testpass path=dbmssrv; select lastname from smithnames;