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.
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.