cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
u57961979
‎04-07-2023
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

merge tables in sas

by Calcite | Level 5 in SAS Programming
‎04-07-2023 04:02 AM
‎04-07-2023 04:02 AM
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. ... View more

Re: return the max value if the dates are progressing

by Calcite | Level 5 in SAS Programming
‎10-06-2022 06:55 AM
‎10-06-2022 06:55 AM
thank you so much ... View more

Re: return the max value if the dates are progressing

by Calcite | Level 5 in SAS Programming
‎10-06-2022 04:46 AM
‎10-06-2022 04:46 AM
No i have only the date and the total ... View more

Re: return the max value if the dates are progressing

by Calcite | Level 5 in SAS Programming
‎10-06-2022 04:29 AM
‎10-06-2022 04:29 AM
yes the date are all consecutive ... View more

return the max value if the dates are progressing

by Calcite | Level 5 in SAS Programming
‎10-06-2022 03:36 AM
‎10-06-2022 03:36 AM
Hello, I need your help. I have to find all the values that have a total over 1 million, but if the dates are progressive, and there are, for example, 3 consecutive dates with a value over 1 million, I have to select only the date with the highest total. in the attached example, it should output as output: dates: 02/01/2000 and 06/01/2000 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-07-2023 09:05 AM
Quick links