topic Re: How to determine matched data in SAS Data Science

How to determine matched data

Courtney-GOV — Thu, 10 Dec 2015 22:25:23 GMT

I have a dataset where we measured a variable with two different systems (visual observations and an automatic system). How can I determine which are matching pairs based on date, time and duration of the activity?

Thank you,

Courtney

Re: How to determine matched data

art297 — Thu, 10 Dec 2015 23:16:12 GMT

Can you provide examples of the two datasets and the criteria you'd like to use to match records?

Art, CEO, AnalystFinder.com

Re: How to determine matched data

ballardw — Fri, 11 Dec 2015 16:37:27 GMT

Will the date and time be exactly the same in both systems? Will the duration be the same in both systems?

Will either data set have observations within the set that overlap in time?Example: Obs 1 has 12/20/2015 12:00:00 duration 1 hour and obs 2 has 12/20/2015 12:15:00 duration 50 minutes. So obs 2 overlaps obs 1.

To allow use of all of the SAS functions involving dates and time it sounds like you may want to make one datetime variable for the start time and a second for the end time as start datetime + duration (in seconds). Then you will be able to test if, or join where, one value is between the others, and possibly within some interval if there is overlapping data involved.