Thank you, this works! I really appreciate it.
I have another question, if you do not mind, since I have your attention.
I need to add values from 1 to X to a numeric variable every time I run my code. The code is being use to clean data files weekly and each file has different data (records).
It is an identifying variable, let's call it ID=.
Each record needs the unique number starting at 1 at first.
I wanted to be able to add the values at the starting point of the first record and be able to continue to assign that number from from where it left off. I would indicate in my code each week that starting point is 5 instead of 1, or 11 instead of 1 (as per example below).
File 1 has 4 records so the ID would be
ID
1
2
3
4
When I run the code again it would pick up from where it left off
File 2
ID
5
6
7
8
9
10
File 3 would start at 11
11
etc
Is this possible?
... View more
