About Kimbraun1

Kimbraun1 · ‎12-10-2019

Hi Paige, Thanks for your reply. The 60 should be <= 60 and >= 0. Yes, the counter starts at 1 each time, but will advance sequentially and not reset at 1 at any point. I so appreciate your help and responsiveness.

Kimbraun1 · ‎12-10-2019

Hi! I'm trying to create a counter variable with multiple conditions. Please see below: the table includes the data in days and the counter I'm trying to program. 1. This is all within a subject. If first subject then start counter = 1. 2. if Days >120 and the lag of the previous Day > 60 then counter =1 if this is the first observation meeting this criteria, 3. If Days >120 and lag of previous Day is <60 then don't add to the counter, rather this observation gets the same as the previous counter number. 4. If Days greater than 0 and LE 120 then +1 to the counter and all other observations <120 are the same counter value. 5. If Days is <0 then counter+1 for each instance. Thank you for any and all assistance. Days Counter 2514 1 141 2 99 3 54 3 0 3 -205 4 -290 5

Kimbraun1 · ‎04-11-2019

Hi, Attached is the sample SAS dataset. I hope that this is what you are looking for. In theory, apples in the second row should never be less than oranges in the first row. If this does occur I would like to flag it as a potential data error, but proceed such that the difference would be negative and fall in the <25 category. Of note, I'm looking to do these differences, etc within subject_id. I think that you already deduced this, but wanted to confirm. Thank you so very much! Kim

Kimbraun1 · ‎04-10-2019

Thank you so much for your reply. Are you asking for me to convert my excel into SAS code with datalines? Subject_id is just the person identifier and there are multiple rows/set of observations for a given person. I want to compare the second row of apples to the first row of oranges and if the difference is < 25 then I compare the third row of apples to the second row of oranges and if the difference is >25 then I populate a new variable for oranges with the 3rd row value for oranges and a new variable for apples populated with the first row for apples value. If the difference is again <25 then I repeat the previous process until I get a difference within the subject_id that is > 25. I hope that the explanation helps. Please let me know about the dataset/datalines and I will post accordingly Best, Kim

Kimbraun1 · ‎04-10-2019

Hi, I'm trying to 1) take the difference between 2 different variables in two consecutive rows, 2) if the difference is < 25 continue to do the same comparison for the next row, 3) output should be in 2 new variables which reflect the first observation and the last observation in the lag. I'm looking for an efficient way to program this. Attached is a sample dataset with the results I would like to see. I am using SAS Enterprise 7.1. Ideas are welcome!!!

Online Status	Offline
Date Last Visited	‎12-10-2019 08:25 AM

Re: Creating a counter variable with mutiple conditional statements

Creating a counter variable with mutiple conditional statements

Re: LAG Function and Do Loop across 2 variables

Re: LAG Function and Do Loop across 2 variables

LAG Function and Do Loop across 2 variables

Re: Creating a counter variable with mutiple conditional statements

Creating a counter variable with mutiple conditional statements

Re: LAG Function and Do Loop across 2 variables

Re: LAG Function and Do Loop across 2 variables

LAG Function and Do Loop across 2 variables