BookmarkSubscribeRSS Feed
Mirisage
Obsidian | Level 7

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

3 REPLIES 3
Cynthia_sas
Diamond | Level 26

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
Super User

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

Litchi
Calcite | Level 5

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;

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1324 views
  • 0 likes
  • 4 in conversation