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?
data want;
set have;
new_value = old_Value + ( _N_ - 1 );
run;
Koen
data want;
set have;
new_num_col = num_col + _n_;
run;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.