Help using Base SAS procedures

Creating a table using Proc tabulate?

Reply
Super Contributor
Posts: 338

Creating a table using Proc tabulate?

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

SAS Super FREQ
Posts: 8,868

Re: Creating a table using Proc tabulate?

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

Super User
Posts: 11,343

Re: Creating a table using Proc tabulate?

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

N/A
Posts: 1

Re: Creating a table using Proc tabulate?

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;

Ask a Question
Discussion stats
  • 3 replies
  • 244 views
  • 0 likes
  • 4 in conversation