I want to use Proc Expand to populate missing observations in a dataset indexed by time, that is, Monthly snapshot dates. The dataset has over 100 fields and I want to use proc expand to fill these gaps since I only have to transform fields that need to be changed and all other fields are treated as explained in step 3 below. The challenge is to get Proc Expand to use the field values for the previous record to fill the missing record. Proc Expand is using the subsequent record to populate the missing record. Also attached are the following: * Output showing my data before and after running proc expand on the data is the piece of code that ... View more