topic Re: Creating a table using Proc tabulate? in SAS Procedures

Creating a table using Proc tabulate?

Mirisage — Wed, 13 Feb 2013 22:43:15 GMT

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

Re: Creating a table using Proc tabulate?

Cynthia_sas — Thu, 14 Feb 2013 05:37:01 GMT

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

Re: Creating a table using Proc tabulate?

ballardw — Thu, 14 Feb 2013 15:30:05 GMT

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

Re: Creating a table using Proc tabulate?

Litchi — Fri, 15 Feb 2013 07:05:05 GMT

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;