260 Selecting and Combining DBMS Data Chapter 13
libname mydblib db2 ssid=db2;
proc freq data=mydblib.invoices(keep=invnum country);
tables country;
title ’Invoice Frequency by Country’;
run;
The following output shows the one-way frequency table that this example generates.
Output 13.20 Using the FREQ Procedure
Invoice Frequency by Country 1
The FREQ Procedure
COUNTRY
Cumulative Cumulative
COUNTRY Frequency Percent Frequency Percent
-------------------------------------------------------------------------
Argentina 2 11.76 2 11.76
Australia 1 5.88 3 17.65
Brazil 4 23.53 7 41.18
USA 10 58.82 17 100.00
Selecting and Combining DBMS Data
This example uses a WHERE statement in a DATA step to create a list that includes
only unpaid bills over $300,000.
libname mydblib oracle user=testuser password=testpass;
proc sql;
create view allinv as
select paidon, billedon, invnum, amtinus, billedto
from mydblib.invoices
quit;
data notpaid (keep=invnum billedto amtinus billedon);
set allinv;
where paidon is missing and amtinus>=300000.00;
run;
proc print data=notpaid label;
format amtinus dollar20.2 billedon datetime9.;
label amtinus=amountinus billedon=billedon
invnum=invoicenum billedto=billedto;
title ’High Bills--Not Paid’;
run;
