@u57961979 wrote:
Hello, I need your help, I have to create 2 tables, in the first one I have all the data of the insurance policies with the due payments, in the other I have the quotas that belong to the company to pay (percentages).
when i apply date db_pol; merge db_polices_total (in=a) quota_share (in=b); by catena; if a;
which works, but if I have 2 policies with the same number, only the first line is populated, the second one does not receive the corresponding quota.
Which variable has the policy number? Do both data sets have multiple values of the same number?
It may help to show us the LOG from running your code. Copy the log text including the code and all messages from that data step. On the forum open a text box with the </> icon above the message window and paste the text.
PS: you misspelled Data as Date above.
... View more