254 Using Other SAS Procedures with DBMS Data Chapter 13
Output 13.13 Creating a DBMS Table
Employees with salaries over $40,000
LASTNAME FIRSTNAME SALARY
WELCH DARIUS $40,858.00
VENTER RANDALL $66,558.00
MARSHBURN JASPER $89,632.00
THOMPSON WAYNE $89,977.00
RHODES JEREMY $40,586.00
KIMANI ANNE $40,899.00
CASTON FRANKLIN $41,690.00
STEPHENSON ADAM $42,178.00
BANADYGA JUSTIN $88,606.00
O’NEAL BRYAN $40,079.00
RIVERS SIMON $53,798.00
MORGAN ALFRED $42,264.00
Using Other SAS Procedures with DBMS Data
The following examples illustrate basic uses of other SAS procedures with librefs
that refer to DBMS data.
Using the MEANS Procedure
This example uses the PRINT and MEANS procedures on a SAS data set created
from the Oracle table March. The MEANS procedure provides information about the
largest number of passengers on each flight.
libname mydblib oracle user=testuser password=testpass;
title ’Number of Passengers per Flight by Date’;
proc print data=mydblib.march noobs;
var dates boarded;
by flight dest;
sumby flight;
sum boarded;
format dates datetime9.;
run;
title ’Maximum Number of Passengers per Flight’;
proc means data=mydblib.march fw=5 maxdec=1 max;
var boarded;
class flight;
run;
Partial output for this example is shown here.
