Hi, I have question of how to code in SAS for the minimum values (amount) up to the index year for each ID. see below for the example: ID year amount Minimum amount Expected value 11 2001 100 Min(100) --- year 2001 100 11 2002 25 Min(100,25) -- year 2001 & 2002 25 11 2003 10 Min(100,25,10) -- year 2001, 2002, 2003 10 11 2004 200 Min(100,25,10,200) 10 22 2002 50 Min(50) 50 22 2006 25 Min(50,25) 25 22 2007 200 Min(50,25,200) 25 22 2008 300 Min(50,25,200,300) 25 How to code it in data statement in order to get the Expected value. Thank you very much in advance.
... View more