Dear, I have not been able to solve the following problem, hopefully you can help me. I have an ID with associated dates, and I need to sort the data by ID, descending date and count these records one by one. for instance: the table I have
proc sort data=have;
by ID descending date;
run;
data want;
set have;
by id descending date;
if first.id then number_order=1;
else number_order+1;
run;
Dear, I have not been able to solve the following problem, hopefully you can help me. I have an ID with associated dates, and I need to sort the data by ID, descending date and count these records one by one. for instance: the table I have
proc sort data=have;
by ID descending date;
run;
data want;
set have;
by id descending date;
if first.id then number_order=1;
else number_order+1;
run;
Dear, I have not been able to solve the following problem, hopefully you can help me. I have an ID with associated dates, and I need to sort the data by ID, descending date and count these records one by one. for instance: the table I have
and this is the result that I should get.
thanks you.
Register Today!
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.