if you have a date or other ordering variable my method would be to: sort your dataset by descending ordering variable/apply the lag function/sort by ordering variable. So basically, your lag becomes your lead.