[R] Analysing data with repeated measure variable

[Ahmad Raza]

Dear Experts,
Greetings

I have the following type of repeated measures data (table 1), and events
data in table 2 (single measure). I want to perform the following tasks (in
R or excel sheet please).

   - To filter subjects who had any response at least 3 days.
   - Response should be > 5 in each day.
   - Then table 1 should have another column, date first response recorded.
   - Then both tables should be merged

Table 1 – Response Data

Sub_No    Response     Date1          5          01-Jan1          5
      02-Jan2          5          01-Jan2          10         02-Jan2
        10         03-Jan2          10         04-Jan2          10
    05-Jan3          10         01-Jan3          10         02-Jan3
      10         03-Jan4          5          01-Jan4          5
  02-Jan4          10         03-Jan4          10         04-Jan4
    10         05-Jan


Table 2 – Event Data

Sub_No   Response        Date1          No2         Yes          30
Jan3         Yes          29 Jan4          No

Thanks for your help.
Regards,

	[[alternative HTML version deleted]]