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