No worries.  I have refined the code to use values from the dataset instead of random numbers and your code works great.  Although the original question had a slightly different context, I still appreciate your solution.   Thanks! ... View more

Can you please explain what this does?  I run your code and get a GROUP= output, but the output value doesn't quite seem to match what I am looking for, and I suspect it could be this code.    VAL=ranuni(0)*200;  Thanks! ... View more

Thanks for your answer.  I realize this next solution may be similar in manner, but how would you best find how many events there are where x > 50 for 10 consecutive seconds (or rows)?  As you may have guessed, I am a beginner at SAS programming.  Your help is greatly appreciated!   Thanks!   ... View more

You are correct.  I am now getting the expected results.  Thanks for the tip! ... View more

982 DATA WORK; 983 set data_full; 984 prior_data = lag(_variable); 985 if _n_=1 and variable < 50 then variable_group=1; 986 if(variable >= 50 and prior_data < 50) or (variable < 50 and prior_data >= 50) then do; 987 variable_group + 1; 988 n_seconds_data = 1; 989 end; 990 else n_seconds_data + 1; 991 drop prior_data; 992 run; NOTE: There were 1200 observations read from the data set WORK.DATA_FULL. NOTE: The data set WORK.WORK has 1200 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 993 994 proc freq data=WORK.data_full; 995 where variable_group > 1 and variable >= 50; ERROR: Variable variable_group is not on file WORK.DATA_FULL. 996 tables n_seconds_data; ERROR: Variable N_SECONDS_DATA not found. 997 run; Yes, when importing from Excel I have noticed changes in variable names; however, the issue looks like it is related to the variables being created in the first step you posted.  They are not being recognized.  Do I need to add these variables to the dataset separately?   Thanks!  ... View more

I appreciate your response.  This is definitely getting me on the right track!  However, I am getting an error.  It is saying the new variables are "not on file" for the dataset.  I did use your code and switched abc for the real variable name.     I imported the data from excel and it lives in a table.  Does this change anything?   Thanks! ... View more