topic merge tables in sas in SAS Programming

merge tables in sas

u57961979 — Fri, 07 Apr 2023 08:02:03 GMT

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.

Re: merge tables in sas

Astounding — Fri, 07 Apr 2023 10:37:43 GMT

First thing to check for: does your db_policies_total data set already contain a percentages variable before the merge. If that's the problem, you can get rid of it using:

date db_pol;
merge db_polices_total (in=a drop=percentages) quota_share (in=b);
by catena;
if a;

Of course, I don't know your variable names. You would have to use the proper name that exists in your data.

Re: merge tables in sas

ballardw — Fri, 07 Apr 2023 15:50:05 GMT

@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.