How to only keep the latest observations with different settings and the same subject number?

tkallday33 — Thu, 16 Oct 2014 17:57:18 GMT

Hello everyone,

I am attempting to only keep the relevant data in my data set, and I am having some trouble. I want to only keep the latest alert setting information for each subject when there was a new setting.

Here is an example of the data set I am using:

obs subject receiver # device time low hi receiver time

1	SM21666728	SM21666728	2	01JAN2009:00:00:13	80	200	3	3	01JAN2009:00:00:13
2	SM21666728	SM21666728	0	02JAN2009:02:46:44	80	200	3	3	02JAN2009:02:46:44
3	SM21666728	SM21666728	1	02JAN2009:02:53:26	80	200	3	3	02JAN2009:02:53:26
4	SM21666728	SM21666728	3	02JAN2009:02:53:27	80	200	3	3	02JAN2009:02:53:27
5	SM21666728	SM21666728	4	02JAN2009:10:14:34	80	200	3	3	02JAN2009:10:14:34
6	SM21666728	SM21666728	6	26APR2012:05:34:55	80	200	3	3	25APR2012:22:34:55
7	SM21666728	SM21666728	7	26APR2012:05:34:56	80	200	3	3	25APR2012:22:34:56
8	SM21666728	SM21666728	8	26APR2012:05:34:57	80	200	3	3	25APR2012:22:34:57
9	SM21666728	SM21666728	9	26APR2012:05:38:31	80	200	3	3	25APR2012:22:38:31
10	SM21666728	SM21666728	10	26APR2012:05:38:40	80	200	3	3	25APR2012:22:38:40
11	SM21666728	SM21666728	12	26APR2012:05:38:41	80	200	3	3	25APR2012:22:38:41
12	SM21666728	SM21666728	5	26APR2012:05:34:55	80	200	3	3	26APR2012:05:34:55
13	SM21666728	SM21666728	14	13DEC2012:17:59:00	80	200	3	3	13DEC2012:10:59:00
14	SM21666728	SM21666728	17	13DEC2012:17:59:30	80	200	3	3	13DEC2012:10:59:30
15	SM21666728	SM21666728	18	13DEC2012:17:59:31	80	200	3	3	13DEC2012:10:59:31
16	SM21666728	SM21666728	19	13DEC2012:17:59:32	80	200	3	3	13DEC2012:10:59:32
17	SM21666728	SM21666728	20	14DEC2012:17:37:41	80	200	3	3	14DEC2012:10:37:41
18	SM21666728	SM21666728	21	14DEC2012:17:38:57	80	200	3	3	14DEC2012:10:38:57
19	SM21666728	SM21666728	22	15DEC2012:21:26:54	80	200	3	3	15DEC2012:14:26:54
20	SM21666728	SM21666728	23	15DEC2012:21:28:15	80	200	3	3	15DEC2012:14:28:15
21	SM21666728	SM21666728	24	16DEC2012:05:40:49	80	220	3	3	15DEC2012:22:40:49
22	SM21666728	SM21666728	25	16DEC2012:05:41:10	100	220	3	3	15DEC2012:22:41:10

So for example, I would only want to keep obs 20, 21, and 22 since they are the ones which have different settings. In reality, I would like to keep the very last occurrence of that setting, but in this example lets just pretend the data set stops at 22. Also, these are all observations for the same subject number... I need a way to do these for each unique subject number.

I have a deadline today and could really use some help ASAP! Thank you guys so much. This is such a great community.

-Tyler

Re: How to only keep the latest observations with different settings and the same subject number?

ballardw — Thu, 16 Oct 2014 19:33:13 GMT

You mention "last occurrence of that setting" but I don't see anything that is obviously related to setting. If you are talking about combinations of LOW and HI this MIGHT do what you want;

proc sort data=have; by subject receiver device_time low hi;

data want ;

set have;

by subject receiver low hi;

if last.low or last.hi;

run;

topic How to only keep the latest observations with different settings and the same subject number? in SAS Programming

How to only keep the latest observations with different settings and the same subject number?

Re: How to only keep the latest observations with different settings and the same subject number?