move a column down and delete last obs in column

[Eva Smith]

i have this table

	date	var1	var2
1	02jan2014	10	3
2	02feb2014	20	6
3	02mar2014	30	9
4	02apr2014	40	12
5	02may2014	50	15
6	02jun2014	60	18
7	02jul2014	70	21
8	02aug2014	80	24
9	02sep2014	90	27

expand 2 in l
sort date
replace date = dofm(mofd(date)+1) in l

	date	var1	var2
1	02jan2014	.	3
2	02feb2014	10	6
3	02mar2014	20	9
4	02apr2014	30	12
5	02may2014	40	15
6	02jun2014	50	18
7	02jul2014	60	21
8	02aug2014	70	24
9	02sep2014	80	27
10	02oct2014	.	27

i need move down var1 and delete in var1 first and last obs.

[ben earnhart]

How about this? In general it's a bad idea to over-write var1, safer to create a new variable, but assuming you are keeping a copy of the file to go back to:

gen temp=var1[_n-1]
replace var1=temp
replace var1=. if _n==_N

should do the trick.

[Eva Smith]

thank you