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

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

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
  • 2108 views
  • 0 likes
  • 2 in conversation