Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Share this Page URL

Updating PROC SQL Views > Updating PROC SQL Views - Pg. 269

proc sql; create view sasuser.raisev as select empid, jobcode, salary format=dollar12., salary/12 as MonthlySalary format=dollar12. from payrollmaster; proc sql; select * from sasuser.raisev where jobcode in ('PT2','PT3'); Salary JobCode MonthlySalary