SAS Advanced programming 정리- PROC SQL (7)

Chapter 7 - Creating and Managing Views Using PROC SQL

Creating a PROC SQL View

proc sql;
create view sasuser.raisev as
select empid, jobcode,
salary format=dollar12.2,
salary/12 as MonthlySalary
format=dollar12.
from payrollmaster
using libname airline 'c:\data\ia';
quit;

Displaying the Definition for a PROC SQL View

proc sql;
describe view sasuser.raisev;
quit;

Log에 definition 명시

Updating a PROC SQL View

proc sql;
update sasuser.raisev
set salary=salary * 1.20
where jobcode='PT3';
quit;

Dropping a PROC SQL View

proc sql;
drop view sasuser.raisev;
quit;