BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Khaladdin
Quartz | Level 8

Hi all,

 

I have a question. I want to ask my question as an example. I have the following datasets:

 

        AAA              Value

          1                    25

          2                     .

          3                     .

          4                    22

          5                     .

 

As you can see, there are some missing observations in column VALUE. I want to equalize this missing value to previous observations. So, the result should be:

 

        AAA              Value

          1                    25

          2                    25 ( because the previous number is 25)

          3                    25 ( because the previous number is 25)

          4                    22

          5                    22 ( because the previous number is 22)

 

Many thanks in advance. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
art297
Opal | Level 21
data want (drop=hold);
  set have;
  retain hold;
  if not missing(value) then hold=value;
  else value=hold;
run;

Art, CEO, AnalystFinder.com

 

View solution in original post

2 REPLIES 2
art297
Opal | Level 21
data want (drop=hold);
  set have;
  retain hold;
  if not missing(value) then hold=value;
  else value=hold;
run;

Art, CEO, AnalystFinder.com

 

Khaladdin
Quartz | Level 8

Many thanks.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Discussion stats
  • 2 replies
  • 1069 views
  • 2 likes
  • 2 in conversation