yipeeee
i got it. i sorted it by descending npi and used a retain statement to create a new variable and assign that variable to npi.