I have a dataset in which i need to identify the first non missing subject within a dose. My data looks like below subject date dose 10002 1/27/2015 10MG 10002 2/24/2015 10MG 10002 6/1/2015 20MG 10002 9/29/2015 10MG 10002 1/24/2016 10MG I want my final dataset to look like below, subject date dose 10002 1/27/2015 10MG 10002 6/1/2015 20MG 10002 9/29/2015 10MG Is there any particular way to do this? If i do first.dose, its giving me only first 2 records of my final dataset.
... View more