BookmarkSubscribeRSS Feed
ydu180
Calcite | Level 5

微信图片_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.

5 REPLIES 5
RW9
Diamond | Level 26 RW9
Diamond | Level 26
data want;
  set have;
  if athlete="" then do;
    athlete="abc";
    age=21;
  end;
run;
ydu180
Calcite | Level 5

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

RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

ydu180
Calcite | Level 5

微信图片_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.

RW9
Diamond | Level 26 RW9
Diamond | Level 26

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>?

Develop Code with SAS Studio

Get started using SAS Studio to write, run and debug your SAS programs.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 2101 views
  • 0 likes
  • 2 in conversation