About Jaap_K

Jaap_K

Hi, That's not exactly what I mean. See Excelfile. Sometimes there is a time difference between two records. In the 'want' example you see new records that 'resolve' the timegap. I'm looking for the code who create these records.

Jaap_K

Hi Bart, The dataset is sorted and is fixed. So you must look at the row above.

Jaap_K

Hi all, I've a dataset with start / end datetimes. Sometimes there is a gap between two records. I want to insert a record where this new record fills the gap between both records. In the example below, a record must be added with start date_time 02FEB2023:22:03:00 and end date_time 03FEB2023:13:23:00. Who can help me with this code? Thanks!

Jaap_K · ‎11-29-2023

Hi, I have a dataset that I want to split based on 2 date columns. In this new column, the date for the intervening months should become the last day of that month Example; Start date Enddate 03Jan2022 05may2022 Result: Start date Enddate NewColumn 03Jan2022 05may2022 03jan2022 03Jan2022 05may2022 28feb2022 03Jan2022 05may2022 31mar2022 03Jan2022 05may2022 30apr2022 03Jan2022 05may2022 05may2022 Thanks for your help!

Online Status	Offline
Date Last Visited	4 weeks ago

Re: How to insert missing datetime records

Re: How to insert missing datetime records

How to insert missing datetime records

Create record per month

Re: How to insert missing datetime records

Re: How to insert missing datetime records

How to insert missing datetime records

Create record per month

SAS Analytics Explorers