How to replace the Missing Value with the correct Value by usingprevious or subsequent value?

Discussion in 'SAS (Statistical Analysis Software)' started by maryann, Apr 6, 2009.

  1. maryann

    maryann Guest

    Please see table Below, some of the eff_Dates are missing. For the
    ones that policy renewed (ex: Policy 1, 2 and 3), we can figure out
    the missing value by add (or substract) one from the previous (or
    subsequent) policy effective date.
    For policies not renewed (ex, Policy 4), there is no way to figure
    out. So just leave it missing

    Policy# Year Effective_Date Correct Effective Date
    1 20040930 . 20040801
    1 20050930 20050801 20050801
    1 20060930 20060801 20060801
    1 20070930 20070801 20070801
    1 20080930 20080801 20080801
    2 20040930 20031001 20031001
    2 20050930 . 20041001
    2 20060930 20051001 20051001
    2 20070930 20061001 20061001
    2 20080930 20071001 20071001
    3 20070930 . 20061101
    3 20080930 20071101 20071101
    4 20080930 . .


    Thanks a lot!

    Maryann
     
    maryann, Apr 6, 2009
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.