I have a data set  with respect to dates as below. I would like to identify and insert the missing date series in each group and rest of the variables value should be previous record data.   Data have: Date                 Employee    var2    var3    var4 ..... ... 01aug2021      Tom 02aug2021      Tom 04aug2021      Tom 05aug2021      Tom 06aug2021      Tom 01Sep2021      John 03sep2021      John 01Sep2021      John   As you can see 03aug2021 is missing in under TOM and 02Sep2021 is missing from John group. Data Want: Date                 Employee    var2    var3    var4 ..... ... 01aug2021      Tom 02aug2021      Tom 03aug2021      Tom 04aug2021      Tom 05aug2021      Tom 06aug2021      Tom 01Sep2021      John 02Sep2021      John 03sep2021      John 01Sep2021      John   ... View more

Hi Team, I have a sas dataset with around 30 variables, Out of which mainly i have concentrate on two variables shown below POL_ID     Amount ----------------------------------- AZN123     $25 ABN456     $44 AZP123     $50 ABC456     $20 CRG020     $60 AZC123     $15 ABP456     $10 NYP020     $50 HRG090     $10 Conditions: 1) Eliminate Duplicate records a)Eliminate records with AZN and retain the record with AZC. b) Eliminate records with AZP and retain the record with AZC. c) Eliminate records with ABN and retain the record with ABC d) Eliminate records with ABP and retain the record with ABC 2) Combine Premium Combine the Amount from the A_N and A_P records with the A_C record. Note: S/w: SAS9.3, O/S: Linux Expected Output(order doesn't matter): POL_ID     Amount ------------------------------------- AZC123     $90 ABC456     $74 NY020       $50 CRG020     $60 HRG090     $10 ... View more