Procedure features: |
CREATE TABLE statement
|
SELECT clause
| column alias |
| FORMAT=
column-modifier |
| object-item | |
|
Other features: |
|
Tables: |
PROCLIB.PAYROLL, PROCLIB.BONUS |
|
This example builds a column with an arithmetic expression and
creates the PROCLIB.BONUS table from the query's result.
PROCLIB.PAYROLL (Partial Listing)
|
|
![[Listing Output]](../common/images/outlist.gif) |
libname proclib 'SAS-data-library';
options nodate pageno=1 linesize=80 pagesize=40;
![Note about code](../common/images/snbut.gif) | proc sql;
create table proclib.bonus as |
![Note about code](../common/images/snbut.gif) | select IdNumber, Salary format=dollar8.,
salary*.025 as Bonus format=dollar8.
from proclib.payroll;
|
![Note about code](../common/images/snbut.gif) | title 'BONUS Information';
select *
from proclib.bonus(obs=10); |
PROCLIB.BONUS
|
|
![[Listing Output]](../common/images/outlist.gif) |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.