General form, DESCRIBE
VIEW statement:
DESCRIBE VIEW proc-sql-view-1<,...proc-sql-view-n>;
proc-sql-view
specifies a PROC SQL
view and can be one of the following:
|
proc sql;
describe view sasuser.faview;
NOTE: SQL view SASUSER.FAVIEW is defined as: select lastname, firstname, gender, INT((TODAY()-dateofbirth)/365.25) as Age, SUBSTR(jobcode, 3, 1) as Level, salary from SASUSER.PAYROLLMASTER, SASUSER.STAFFMASTER where jobcode contains 'FA' and (staffmaster.empid=payrollmaster.empid); |