Write and run SAS programs in your web browser

fill up missing values

Reply
Contributor
Posts: 23

fill up missing values

微信图片_20170705215735.pngDoes anyone know how to filling this missing values? I have information to fill, but I don't know how to locate these three and then assign, as other variables are the same.

Super User
Super User
Posts: 7,392

Re: fill up missing values

data want;
  set have;
  if athlete="" then do;
    athlete="abc";
    age=21;
  end;
run;
Contributor
Posts: 23

Re: fill up missing values

How could I do if three missing Athletes have different age?

Super User
Super User
Posts: 7,392

Re: fill up missing values

You need to provide some information on what you are doing I can't guess.  Post test data in the form of a datastep, post example output that you want, explain the logic between the two.

Contributor
Posts: 23

Re: fill up missing values

微信图片_20170705223418.png微信图片_20170705223423.pngThe first one is my results, there are three missing value. The second is the information. I need to find the three and three them up.

Super User
Super User
Posts: 7,392

Re: fill up missing values

And how do I know that row 4009 should contain <insert correct data>?  And how to know the row 4010 should contain <insert correct data>?

Ask a Question
Discussion stats
  • 5 replies
  • 161 views
  • 0 likes
  • 2 in conversation