I am trying to generate a variable to tell me when a change in values has occurred down one column.
Example of data
| Column | generated variable |
| 1 | 1 |
| 1 | 0 |
| 1 | 0 |
| 2 | 1 |
| 4 | 1 |
| 4 | 0 |
| 4 | 0 |
| 4 | 0 |
| 5 | 1 |
| 5 | 0 |
| 2 | 1 |
| 4 | 1 |
| 4 | 0 |
| 4 | 0 |
| 6 | 1 |
| 6 | 0 |
| 6 | 0 |
| 6 | 0 |
| 6 | 0 |
Code:
gen generated variable = Column == value1 & (Column [_n-1] ~= value1 )
Thankyou
0 Response to Change of variable in one column
Post a Comment