move a column up

[Eva Smith]

how i can do this

title

1

2

3

4

5

6

title

2

3

4

5

6

.

[Rich Goldstein]

try this:

replace title=title[_n+1]

[Eva Smith]

thank you

[Eva Smith]

and how to move down ?

[Jorrit Gosens]

replace title=title[_n-1]

[Sergiy Radyakin]

No, Jorrit Gosens that will not work. That will just replace all values in that column with missings.

// incorrect way
sysuse auto, clear
replace make=make[_n-1]
list make price

// correct way (one of)
sysuse auto, clear
tempvar idx
generate long `idx'=_n
gsort -`idx'
replace make=make[_n+1]
gsort `idx'
drop `idx'
list make price

[daniel klein]

May ask why one would want to do such things?

Seems like a good idea to do it via reproducible syntax anyway.

Best
Daniel

[Jorrit Gosens]

Ah, I spoke too soon, apologies. Won't work because it starts making the changes from the top, and finds a missing for every next change it wants to make, yes?