PROC TABULATE/PROC FREQ - Save 2*2 matrices (Loan transition matrices)

PROC TABULATE/PROC FREQ - Save 2*2 matrices (Loan transition matrices)

Post by hiemstr » Wed, 27 Feb 2008 01:45:54


I am using PROC TABULATE to generate loan transition matrices on the
number of loans and their dollar value. I want to save these data for
further programming. The logic of the process is to generate a
frequency table of the loan classifications on their classifications
in the previous quarter.

I can print the matrices from PROC TABULATE, but I am not sure how to
save them for further processing. Can someone lend me hand in saving
them with PROC TABULATE or must I program out the same activitity in
PROC FREQ? If so, how do I get SAS to do this in PROC FREQ?

Stephen

This code works:

TITLE1 "PROC TABULATE ON QUARTERS (&__qtr1) AND (&__qtr2).";

PROC TABULATE DATA=WORK.tmp;
BY qtrly_activity_dte;
CLASS lag_status_cde loan_status_cde;
VAR cur_upb_amt;
TABLE lag_status_cde, loan_status_cde * (N="Number of loans"
cur_upb_amt="UPB
in dollars")*f=COMMA17.;
FORMAT loan_status_cde $loan_status. lag_status_cde $loan_status.;
RUN;