topic Add a count column in SAS Programming

Add a count column

Jose7 — Mon, 12 Dec 2022 06:14:21 GMT

Hi experts

I have a table like this

And i Want to add a column making a count like this

Do you have any idea how to make it ?

Kurt_Bremser — Mon, 12 Dec 2022 06:51:47 GMT

data want;
set have;
by id;
if first.id
then count = 1;
else count + 1;
run;

The SUM Statement in the ELSE implies an automatic RETAIN of the new variable.

Jose7 — Mon, 12 Dec 2022 17:51:31 GMT

Thks! it works !