0 - 1 of 1 tags for retain

Given the data below, I need to create an observation for 7/5/2014.  I also need to retain the values from the previous record (record of Period_date=7/4/2014) for this exercise.  I am using the table SYS_CALENDAR.CALENDAR and I have tried both a CROSS and FULL JOINs but was unsuccessful with obtaining the output desired.  Additional requirements is to tr