I have the following data set C1 and I would like to select the highest value before 4 hours and the highest value after 4 hours for each subject. I tried proc seql to select values prior to 4 hrs with no luck. Can someone tell me how to properly do this with either proc seql or a data step?
PROC SQL; CREATE TABLE CMAX AS SELECT SUBJECT where time in (0 0.25 0.5 1 1.5 2 3 4 ), COUNT(SUBJECT) AS N, DATA FORMAT=DATE7.,cMAX, MAX(DV) AS CMAXHIGH, FROM C1 GROUP BY SUBJECT; QUIT;
SUBJECT
TIME
CMT
DV
1
0
11
0
1
0.25
11
0
1
0.5
11
2.7695
1
1
11
3.4254
1
1.5
11
6.2236
1
2
11
5.7419
1
3
11
4.4998
1
4
11
5.3484
1
5
11
8.4798
1
6
11
10.843
1
6.5
11
10.545
1
7
11
6.8125
1
7.5
11
8.7324
1
8
11
7.752
1
10
11
5.8673
1
12
11
1.9105
1
16
11
1.4909
1
24
11
1.9336
2
0
11
0
2
0.25
11
0
2
0.5
11
2.0534
2
1
11
1.9252
2
1.5
11
1.1755
2
2
11
2.7677
2
3
11
4.9696
2
4
11
7.29
2
5
11
12.178
2
6
11
12.825
2
6.5
11
13.286
2
7
11
14.776
2
7.5
11
9.8487
2
8
11
7.5002
2
10
11
5.2042
2
12
11
5.1375
2
16
11
2.7229
2
24
11
0
... View more
