topic Re: fill up missing values in SAS Studio

fill up missing values

ydu180 — Wed, 05 Jul 2017 14:00:06 GMT

Does 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.

Re: fill up missing values

RW9 — Wed, 05 Jul 2017 14:05:48 GMT

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

Re: fill up missing values

ydu180 — Wed, 05 Jul 2017 14:23:33 GMT

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

Re: fill up missing values

RW9 — Wed, 05 Jul 2017 14:31:29 GMT

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.

Re: fill up missing values

ydu180 — Wed, 05 Jul 2017 14:37:06 GMT

The 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.

Re: fill up missing values

RW9 — Wed, 05 Jul 2017 14:50:32 GMT

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