Hi everyone,
If i have a data which is the following
data t;INPUT x;
cards;1212312;
This data set is merged from each person.
So, its id should be 1 1 2 2 2 3 3.
How could I get the the id I want? I have tried use the if first statement, but I failed.
Please tell me the easiest way to do it.
This would be one way:
data want;
set have;
priorx = lag(x);
if _n_=1 or x <= priorx then id + 1;
drop priorx;
run;
This assumes that when X stays the same from one observation to the next, that the ID should be different.
Good luck.
View solution in original post
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Save the date!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.