Hi,
After sorting by date and ID, I am trying to select the first row per id that meets a certain criteria (x > 1), but if none of the rows (per id) meet this criteria, I want to select the last row for that id?
I appreciate any help, thanks.
Natalia
data want;
set have;
by ID;
*hold value of flag across rows;
retain flag;
*initialize flag to 0 at start of each ID;
if first.id then flag=0;
*check if x >1 and flag is not 0 - has not happened before;
if x>1 and flag ne 1 then do;
*set flag so you know it has been found;
flag=1;
*output record to dataset;
output;
end;
*if last of the ID and flag is still 0 then output as well;
if last.id and flag=0 then output;
run;
@nataliavanessa0 wrote:
Hi,
After sorting by date and ID, I am trying to select the first row per id that meets a certain criteria (x > 1), but if none of the rows (per id) meet this criteria, I want to select the last row for that id?
I appreciate any help, thanks.
Natalia
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.