Hi all, can you give your valid comments to solve this type of query.
i have two datasets
1. annuity
2. policy
annuity variables are account_no, account_value, policy_no.
policy variables are policy_no, year, p_type.
in policy_type we have the different types suppose A,B,C,D,E,F,G,H.
We consider A,B,C,D are one type let us consider it as reg_policy. The remaining all are individual.
now we want the output like
Account Number | Sum_of_acccontvalue | No_of_policies | ranks | ||||||||||
2010 | 2011 | 2012 | 2013 | 2014 | 2010 | 2011 | 2012 | 2013 | 2014 | 2010 | 2011 | 2012 | |
|
|
|
|
|
|
The condition is that
1. If the no_of_policies example like in 2010 is 100 then policy_type in that reg_policy is the maximum value compare to remaining all. We want only that information.
2. Ranks are given based on sum_of_accountvalue with year wise.
Could you give data set example and the desired output.
Quite a complex query from what it sounds. Why don't you give it a go and get back to us with some more specific question?
You need definitely to provide some representative sample data.
"annuity variables are account_no, account_value, policy_no"
Shouldn't there also be a "date" variable in annuity? Else how would you be able to create account_value sums by year, and how would you join "annuity" with "policy"?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.