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
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
Are there multiple records for each account number in the data?
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.