To get repeated value for missing value

[Reema]

Hi Everyone,

After trying the following codes:

data Enrolid_SD;
	Set S.MS_Enrolid;
	By enrolid svcdate;
	If first. enrolid then Index_Dt = Svcdate;
	format Index_Dt date9.;
run;

I am getting output like this: 

1	497201	02MAR2011	1928	02MAR2011
2	497201	08JUN2011	1928	.

3	497201	10OCT2011	1928	.
4	497201	10JAN2012	1928	.

5	581601	18JUN2009	1934	18JUN2009
6	581601	14DEC2009	1934	.

7	1203301	15MAR2011	1928	15MAR2011
8	1234801	20MAY2009	1939	20MAY2009

9

1257301

09FEB2012

1928

09FEB2012

But I want output like this i.e. I don't want any missing index_dt value, but I want the previous index_dt there.

1	497201	02MAR2011	1928	02MAR2011
2	497201	08JUN2011	1928	02MAR2011

3	497201	10OCT2011	1928	02MAR2011
4	497201	10JAN2012	1928	02MAR2011

5	581601	18JUN2009	1934	18JUN2009
6	581601	14DEC2009	1934	18JUN2009

7	1203301	15MAR2011	1928	15MAR2011
8	1234801	20MAY2009	1939	20MAY2009

9

1257301

09FEB2012

1928

09FEB2012

Someone please look into it and provide easy codes.

Thanks!

[Shmuel]

I have the feeling that you miss a line after the BY ...

    RETAIN SVCDATE;

[Shmuel · Accepted solution]

Sorry - it shold be:

    RETAIN INDEX_DT;

[Reema]

Thanks Shmuel.. but actually it must be:
retain index_dt; /* after by statement */

I have checked.

Please edit your comment, then I will mark it as a solution.