Thanks.  I found that article and tried a few of them and they are still rounding to 1.  I tried this specifically thinking it would be the one.   d7 = round(1234.56789,.0001) - 1234.5679; ... View more

Thank you Xia,   This is a lot closer, however, it looks like it is populating the value of the next observation rather than the previous.   ... View more

My understanding is that I would need to create it to hold the previous obvservation's variable.  If it is not necessary then it is not needed.  I am sure I was making it more complicated than it needs to be but I just can't get there. ... View more

Thanks Astounding....   When I change my code to run this I get all zero's in that column.   I am running DATA FLOWFRED.FMFLOW_PIPELINE_HISTSUM_CHART; SET FLOWFRED.FMFLOW_PIPELINE_HISTSUM_ARCHIVE; retain PREV_TOTAL_NOTE_BALANCE_15YR 0; IF TOTAL_NOTE_BALANCE_15YR > . THEN PREV_RUNNING_NOTE_BALANCE_15YR=TOTAL_NOTE_BALANCE_15YR; ELSE TOTAL_NOTE_BALANCE_15YR=PREV_TOTAL_NOTE_BALANCE_15YR; run; I attached new sample data from this run.  As you can see, the PREV_TOTAL_NOTE_BALANCE_15YR variable shows 0 for every observation.  The PREV_RUNNING_NOTE_BALANCE_15YR is only populating for the observations with data.  I need the data to carry over from the previous observation if the current is missing. So, 12/31/15 data (identical) through 1/3/2016 since those observations have no data.  ... View more

Thanks guys.  Here is the code I have been working with.  I also attached an excel file with the data.   proc sql;     insert into FLOWFRED.FMFLOW_PIPELINE_HISTSUM_ARCHIVE         select             d.Date,             ln.DATE_ADDED,             ln.PCT_TOTAL_UPB_15YR,             ln.PCT_TOTAL_UPB_20YR,             ln.PCT_TOTAL_UPB_30YR,             ln.TOTAL_NOTE_BALANCE_15YR,             ln.TOTAL_NOTE_BALANCE_20YR,             ln.TOTAL_NOTE_BALANCE_30YR         from MSRCOM.MSRCOM_DATE_TABLE d             left join FLOWFRED.FMFLOW_LOANSINPIPELINE_HISTSUM ln on ln.DATE_ADDED = d.Date             left join FLOWFRED.FMFLOW_BEGIN_DATES bd on bd.DATE_MOST_RECENT = ln.DATE_ADDED             /*left join FLOWFRED.FMFLOW_PIPELINE_HISTSUM_UPDARC ar on ar.Date = d.Date*/         where d.Date <= bd.DATE_MOST_RECENT; quit; DATA FLOWFRED.FMFLOW_PIPELINE_HISTSUM_CHART;     SET FLOWFRED.FMFLOW_PIPELINE_HISTSUM_ARCHIVE;         retain PREV_TOTAL_NOTE_BALANCE_15YR 0;         retain PREV_TOTAL_NOTE_BALANCE_20YR 0;         retain PREV_TOTAL_NOTE_BALANCE_30YR 0;         IF MISSING(TOTAL_NOTE_BALANCE_15YR) = 1 THEN TOTAL_NOTE_BALANCE_15YR=SUM(PREV_RUNNING_NOTE_BALANCE_15YR,TOTAL_NOTE_BALANCE_15YR);                 ELSE TOTAL_NOTE_BALANCE_15YR=TOTAL_NOTE_BALANCE_15YR; run; ... View more

Good call.  I hadn't thought of using that.  I mainly want to do this for development purposes so this should work well.  Thank you! ... View more

Thanks Reeza.  After taking the sort out of my initial query this worked.  I appreciate all of the answers everyone! ... View more

Thanks again, this worked great.  However, now that I have the running totals, I would like to have everything sorted in descending order with the most recent date.  That means I would like the running total descending along with the date.  I can get the date sorted descending easily but the running total will not sort that way with the date.  Any ideas? ... View more

Thanks  mohamed_zaki and ballardw... I will try this as soon as I can.  I appreciate the help.  I will mark this solved asap.   Happy New Year! ... View more

Sure, thanks.   As you can see... the running total works in the original data set (created with proc sql).  The problem I have is that the running total doesn't carry forward if there is a missing value in NOTE_BALANCE_15YR.  For example, on row 7 there is a missing value for NOTE_BALANCE_15YR so the RUNNING_NOTE_BALANCE_15YR is also missing.  I need the RUNNING_NOTE_BALANCE_15YR from row 6 (FALLOUT_DATE 8/12/2015) to carry forward until the next record with a value occurs (row 12, FALLOUT_DATE 8/25/2015).   ... View more