BookmarkSubscribeRSS Feed
Ravikumarkummari
Quartz | Level 8

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.

3 REPLIES 3
mohamed_zaki
Barite | Level 11

Could you give data set example and the desired output.

LinusH
Tourmaline | Level 20

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?

Data never sleeps
Patrick
Opal | Level 21

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"?

sas-innovate-2024.png

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.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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