Creating a table using Proc tabulate?

[Mirisage]

Hi SAS Forum,

I have just a few minutes ago posted a SAS query with the same heading.

I realized that the table I need to create is not clear in the posting.

So, I am attaching it as an Excel file for clarity. Aplogize for multiple postings.

Thanks

Mirisage

[Cynthia_sas]

Hi:

It is good to have an example of the output you want. What code have you tried? What does your input data look like? You're the only one who knows what your input data looks like? Does it look like SASHELP.SHOES, does it look like SASHELP.PRDSALE? The structure of the input data must be known in order to code a solution.

cynthia

[ballardw]

Are there multiple records for each account number in the data?

[Litchi]

proc tabulate;

class prev_arreras cur_arrears;

var account_number prev_bal cur_bal;

table ((prev_arreras all='Total')*(n*account_number sum*prev_bal sum*cur_bal)), (cur_arrears all='Total');

run;