The following examples illustrate basic uses of other SAS procedures with librefs that refer to DBMS data. Using the MEANS Procedure ... display a chart of the number of employees for each job code.

The AVG function in the SQL procedure is equivalent to the SAS MEAN function. options linesize=80; proc access dbms=db2; /* create access descriptor */ create adlib.employ.access; ssid=db2; ...