I have multiple different data sets, and I am trying to use two at a time for calculations. For instance:
I have a dataset with approximately 90,000 rows, each row has columns: policy , age, gender, loyalty (years with company), smoker, zip code, accidents, premium.
I have another dataset with 6 rows. each row has columns: accidents, Charge.
What I am trying to do is take the accidents from the first dataset for each row and reference that number of accidents with the same number in the second dataset under the accidents column, and then use what is in the charge column for that many accidents (by row) as a multiplier.
I have spent a few hours trying different things and haven't really come up with any solutions.
EDIT: I have uploaded a visual I quickly made to make it easier to understand what I am trying to accomplish
I'm not having any luck with that info. All I can figure out how to do with a lookup is take an individual policy and perform my desired actions, I need to create a new table with every value from one dataset multiplied by its corresponding value from the other dataset
input policy gender$ age loyalty smoker$ zipcode accidents annual_premium;
2 M 71 1 N 10468 0 1371.05
3 F 63 2 M 10500 1 865.34
input accidents charge;
merge one (in=a)
if a and b;
new_premium = annual_premium*charge;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.