Prev: Preserving leading blanks when importing Excel sheet
Next: Reading variable length file
From: SD on 12 Aug 2010 08:41
Hello Everyone,

I have a data set :

Year region country product share
2000 AP TW milk_1 10
2001 AP TW milk_1 missing
2002 AP TW milk_1 missing
2003 AP TW milk_1 missing
2004 AP TW milk_1 6.5
2005 AP TW milk_1 5
2006 AP TW milk_1 5.3
2007 AP TW milk_1 4
2008 AP TW milk_1 missing
2000 AP TW milk_2 1
2001 AP TW milk_2 missing
2002 AP TW milk_2 missing
2003 AP TW milk_2 missing
2004 AP TW milk_2 6.5
2005 AP TW milk_2 5
2006 AP TW milk_2 missing
2007 AP TW milk_2 missing
2008 AP TW milk_2 4


Would like help on a code/logic which would help in filling up
"missing" values through some decay method.

Appreciate any help on this .

thanks
SD

From: Barry Schwarz on 13 Aug 2010 00:21
On Thu, 12 Aug 2010 05:41:54 -0700 (PDT), SD <saurabhkdas(a)gmail.com>
wrote:

>Hello Everyone,
>
>I have a data set :
>
>Year region country product share
>2000 AP TW milk_1 10
>2001 AP TW milk_1 missing
>2002 AP TW milk_1 missing
>2003 AP TW milk_1 missing
>2004 AP TW milk_1 6.5
>2005 AP TW milk_1 5
>2006 AP TW milk_1 5.3
>2007 AP TW milk_1 4
>2008 AP TW milk_1 missing
>2000 AP TW milk_2 1
>2001 AP TW milk_2 missing
>2002 AP TW milk_2 missing
>2003 AP TW milk_2 missing
>2004 AP TW milk_2 6.5
>2005 AP TW milk_2 5
>2006 AP TW milk_2 missing
>2007 AP TW milk_2 missing
>2008 AP TW milk_2 4
>
>
>Would like help on a code/logic which would help in filling up
>"missing" values through some decay method.

Look at the IF and RETAIN statements.

--
Remove del for email
 | 
Pages: 1
Prev: Preserving leading blanks when importing Excel sheet
Next: Reading variable length file