I want to select the first instance where the var1 value is >= 0.5; Help please data have; input id visitid pageid date var1 start_date; datalines; 1 1 1 10/1/2019 0.1 9/30/2019 1 1 2 10/2/2019 0.2 9/30/2019 1 1 2 10/3/2019 0.5 9/30/2019 1 2 1 10/4/2019 1 9/30/2019 1 2 2 10/5/2019 3 9/30/2019 1 2 3 10/6/2019 5 9/30/2019 2 1 1 9/28/2019 0.1 9/27/2019 2 1 2 9/29/2019 0.2 9/27/2019 2 1 2 9/29/2019 0.5 9/27/2019 2 1 3 10/4/2019 1 9/27/2019 2 2 1 10/5/2019 3 9/27/2019 2 2 2 10/6/2019 5 9/27/2019 ; run; data want; input id visitid pageid date var1 start_date; datalines; 1 1 2 10/3/2019 0.5 9/30/2019 2 1 2 9/29/2019 0.5 9/27/2019 ; run;
... View more