topic Re: Increment numeric value by one for each row in SAS Enterprise Guide

Increment numeric value by one for each row

Sean_OConnor — Thu, 31 Mar 2022 12:50:28 GMT

Hi,

I have a numeric column which has all rows equal to 810,225.

I would like to create a new column which increments this value by one for each row. So row one would equal 810,225 row 2 would be 810,226, row 3 would be 810,227 and so on.

Could anyone provide some advice as the best way to do this?

Re: Increment numeric value by one for each row

sbxkoenk — Thu, 31 Mar 2022 12:55:37 GMT

data want;
 set have;
 new_value = old_Value + ( _N_ - 1 );
run;

Koen

Re: Increment numeric value by one for each row

andreas_lds — Thu, 31 Mar 2022 13:21:27 GMT

data want;
  set have;
  new_num_col = num_col + _n_;
run;