DATA Step, Macro, Functions and more

To get repeated value for missing value

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

To get repeated value for missing value

[ Edited ]

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!

 

 


Accepted Solutions
Solution
‎09-04-2016 05:09 AM
Trusted Advisor
Posts: 1,579

Re: To get repeated value for missing value

Sorry - it shold be:

    RETAIN INDEX_DT;

View solution in original post


All Replies
Trusted Advisor
Posts: 1,579

Re: To get repeated value for missing value

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

    RETAIN SVCDATE;

Solution
‎09-04-2016 05:09 AM
Trusted Advisor
Posts: 1,579

Re: To get repeated value for missing value

Sorry - it shold be:

    RETAIN INDEX_DT;

Occasional Contributor
Posts: 7

Re: To get repeated value for missing value

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.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 221 views
  • 2 likes
  • 2 in conversation