02-01-2016 07:10 PM - edited 02-01-2016 07:18 PM
I am looking for syntax to change the missing values of a variable to the average of the remaining values of the same variable
for the variable duration-
duration : 10 20 30 40 . . . ( . meaning missing values )
I want to replace the three missing values with the average of 10 20 30 40. I want to repliate this over a variable having more than 1000 values.
Can anyone help me out ?
02-25-2016 04:08 AM
Not having a nested clause speeds things up a bit.
create table WANT as
select coalesce(DURATION, mean(DURATION) ) as DURATION