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"?
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.