I'm trying to figure out how to impute missing values with the most recent value. I found a paper (https://documentation.sas.com/?docsetId=casdspgm&docsetTarget=p0x15q4nde1191n10s3x42uy4epc.htm&docsetVersion=3.2&locale=en), but it seems to assume an upper bound for the gap between non-missing values. Lets say we have the following dataset: class Group 1001 A 1002 B 1003 C 1003 1003 C 1020 D 1020 1020 1020 1020 Desired output: class Group 1001 A 1002 B 1003 C 1003 C 1003 C 1020 D 1020 D 1020 D 1020 D 1020 D Assume the group stays consistent within all classes and the first instance of the class always has a filled in group. The number of records in a class is variable. I tried using the first function, but I keep getting a value of 1 even though the Group variable is composed of characters or strings, so I'm not sure whats happening there.
... View more