Thanks so much. I really appreciate it.    So basically I want scatter line connect plot. X-axis = date_time and y-axis should be volume_1 and volume_2. Each graph should show id and group name. The y-axis should say: "Volume'   Something like this:   id date_time volume_1 volume_2 group 1 4/19/14 9:51 PM     placebo 1 4/19/14 9:56 PM 41.75 6.20 placebo 1 4/20/14 12:53 PM 50.82 5.00 placebo 1 4/21/14 8:38 PM 51.77 4.70 placebo 1 4/22/14 5:51 PM     placebo 2 4/23/14 1:34 PM 55.18 6.00 drug 2 7/3/14 12:50 AM 14.31 2.40 drug 2 7/3/14 3:34 PM 12.68 0.80 drug 2 7/3/14 9:00 PM 10.99 0.90 drug 2 7/4/14 3:30 PM 8.16 1.20 drug ... View more

Thank you so much! It works!! Couple more questions - Is there any way that I can include the randomization_date and treatment group on the graph title or something? I don't need on the line graph but next the to ID name? - Also right now, my y axis is showing volume_1. How do I relabel as "Volume" only? Since this is a line graph, is there any way I can get scatter dot?    Thank you! ... View more

Hi!   1. Each ID is unique but have multiple entries. so we count the first occurence of >=170 onwards 2. Yes, it'd be helpful to extract them into a new dataset if first >=170 then second >=200 and then the third is >=200 3. If the last row for that ID is >=170, new dataset would be helpful!    Thank you!! ... View more

Yes. I think that's where I am having trouble setting it to missing value or adding an flag 😕 ... View more

I think that's where I am having trouble with adding Flags as SAS. I created if else statment but it is not working   thanks! ... View more

I have dataset that look like this. What I would like to do is I would like to see if the there are TWO continuous values >=170. I - If they are, then I would like to take average of those two numbers. However if the there are three continuous values above >=170 and atleast two of them are >200 then I would like to indicate it as check =1.  - iF there is only one >=170, i would like to see if the group has any other two consequentive numbers that are >=170. If not, check = 2     id val seq 1 145 1 1 201 2 1 183 3 1 210 4 2 165 1 2 199 2 2 210 3 2 175 4 3 175 1 3 149 2 3 175 3 3 180 4 3 145 5 4 145 1 4 175 2 4 144 3 4 134 4     Sample output: id val seq average check 1 145 1     1 201 2 192 1 1 183 3     1 210 4     2 165 1     2 199 2 205 0 2 210 3     2 175 4     3 175 1     3 149 2     3 175 3 178 0 3 180 4     3 145 5 <170 2 4 145 1     4 175 2     4 144 3     4 134 4     ... View more

Hello. Thank you. What if the first value is not >=170? I would like to see if the next two consequentives are.  ... View more

Hello I tried but I am not getting what I am hoping for:   data want; if value >=170 and _value<=199 then check='1'; if lag(value )>200 and lag2(value )> 200 then case="check";run; ... View more

Hello. It works!!!   One quick question. What if it looked like this? For example if the two continuous cases are above 170 then i am not worried about next entries REGARDLESS OF The case above?   ID seq_id val yes case 1 1 169     1 2 184  0 no check 1 3 175     1 4 142     1 5 184     1 6 211     1 7 217       THANK YOU! ... View more