s**********l 发帖数: 395 | 1 Policy data:
Policy# age Policy take effective date
1 24 01/01/2008
1 24 01/07/2008
2 50 06/15/2007
3 25 04/11/2006...
Claim data:
Policy# loss Claim date
1 1000 02/05/2008
2 2000 06/30/2007
3 3000 07/15/2007
4 4000 ...
given the above two data sets and we are asked to combine these two data
sets to find the age for each claim loss.(This requires that the claim date
is within 180 days since the policy take effective, in other words that the
claim date- date the policy take effective should be smaller or equal to 180
days.) The question is why can't use the merge procedure using the
following code? Instead I should use SAS SQL procedure? If someone knows,
could you explain why and how to combine the data with PROC SQL? Thank you
so much. | R*********i 发帖数: 7643 | 2 As there are more than one individual covered by a same policy number in
dataset 1 (Policy data), there might also be more than one claim under a
same policy number in dataset 2 (Claim data) and you want to have a multiple
-to-multiple merge which will be handled nicely by sql full join. Good luck! |
|