topic Re: How to replace missing values in SAS Programming

How to replace missing values

Sudheer1 — Fri, 14 Sep 2018 06:55:30 GMT

How to replace missing values of a variable with the mean of another variable.

For example:

Replace the missing values for V1 with the average V2 on V3,V4 and V5.

Re: How to replace missing values

andreas_lds — Fri, 14 Sep 2018 07:01:38 GMT

Something like

if missing(v1) then do;
    v1 = mean(v2, v3, v4, v5);
end;

Re: How to replace missing values

s_lassen — Fri, 14 Sep 2018 10:20:04 GMT

You can also use the COALESCE function, which makes for simpler code:

V1=coalesce(V1,mean(of v2-v5));

Re: How to replace missing values

Sudheer1 — Mon, 17 Sep 2018 05:06:03 GMT

How to find missing value with the mean of V1 if V1 is numerical variable and V2,V3 & V4 are categorical variables ?

Re: How to replace missing values

ChrisNZ — Mon, 17 Sep 2018 05:24:09 GMT

1. Have you tried the suggestions given?

If not, please do it and report.

2. So you want to calculate the average for numbers contained in character variables?

Re: How to replace missing values

Sudheer1 — Mon, 17 Sep 2018 05:28:31 GMT

I need to find missing value for by using mean of V1 and group by V2, V3 &
V4.

Re: How to replace missing values

Jagadishkatam — Mon, 17 Sep 2018 05:37:56 GMT

Hi Sudheer

please provide the data structure or an example dataset you have and expected output to get better response and solution.

Depending on the structure of the data the code will change.

Re: How to replace missing values

Sudheer1 — Mon, 17 Sep 2018 06:20:20 GMT

Hi Jagadish,

I need to replace the missing values for distance with mean of distance and group by carrier, origin and dest.

Please find the sample data below:

date	sched_dep_time	dep_time	sched_arr_time	arr_time	carrier	flight	tailnum	origin	dest	distance
1/1/2013	515	517	819	830	UA	1545	N14228	EWR	IAH	1400
1/1/2013	529	533	830	850	UA	1714	N24211	LGA	IAH	1416
1/1/2013	540	542	850	923	AA	1141	N619AA	JFK	MIA	.
1/1/2013	545	544	1022	1004	B6	725	N804JB	JFK	BQN	1576
1/1/2013	600	554	837	812	DL	461	N668DN	LGA	ATL	762
1/1/2013	558	554	728	740	UA	1696	N39463	EWR	ORD	719
1/1/2013	600	555	854	913	B6	507	N516JB	EWR	FLL	1065