How to impute the first observation value in the entire row

venkatard — Tue, 26 Mar 2013 04:55:08 GMT

Re: How to impute the first observation value in the entire row

Jagadishkatam — Tue, 26 Mar 2013 05:20:09 GMT

Hi,

An example with an output you desire to get will helps us to provide a proper code.

Thanks,

Jagadish

Re: How to impute the first observation value in the entire row

Jagadishkatam — Sun, 31 Mar 2013 04:30:20 GMT

Hi,

Just thought to inform you that, for your query if you consider that you have a data as below and you want the first row values to be replaced with 0.

Obs letter num1 num2 num3 num4

1 a 100 1 101 1111

2 b 20 222 . .

3 c 33 . . .

4 d 444 40 . .

5 e . . . .

6 f . . . .

7 g . . . .

8 h 88 . . .

Here is the code that will produce the output you desire to get

data have;

set final;

array mis(4) num1-num4;

do i = 1 to 4;

if _n_=1 then mis(i)=0;

end;

run;

Obs letter num1 num2 num3 num4 i

1 a 0 0 0 0 5

2 b 20 222 . . 5

3 c 33 . . . 5

4 d 444 40 . . 5

5 e . . . . 5

6 f . . . . 5

7 g . . . . 5

8 h 88 . . . 5

See the first row column values are replaced with 0. Hope this helps you.

Thanks,

Jagadish

Re: How to impute the first observation value in the entire row

allurai0412 — Mon, 01 Apr 2013 06:28:59 GMT

hi,

i made some modifications to jagadish help,

.....'If you want particlulary the first......observation to be imputed to entire row'' the follwing will helps you..

Note : if first obs is 'Numeric' ...then only this would helps...

data ddd;
input first num1 num2;
datalines;
12 33 56
23 44 67
22 56 78
;
run;

data want(drop =i);
set ddd;
array mis(2) num1-num2;
do i = 1 to 2;

mis(i)=first;

end;
run;

Regards

ALLU

topic Re: How to impute the first observation value in the entire row in SAS Programming

How to impute the first observation value in the entire row

Re: How to impute the first observation value in the entire row

Re: How to impute the first observation value in the entire row

Re: How to impute the first observation value in the entire row