|
|
Filling up missing data
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
|
|
0
|
|
|
|
Reply
|
 saurabhkdas (53)
|
8/12/2010 12:41:54 PM |
|
On Thu, 12 Aug 2010 05:41:54 -0700 (PDT), SD <saurabhkdas@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
|
|
|
0
|
|
|
|
Reply
|
 Barry
|
8/13/2010 4:21:23 AM
|
|
|
1 Replies
432 Views
(page loaded in 0.045 seconds)
Similiar Articles: Filling up missing data - comp.soft-sys.sasHello 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 missin... correlation on large data set - comp.soft-sys.sas... instance I would do this by looping over the rows then the columns and filling up ... to do this given my X is large (60 million observations) and contains missing data. replace missing value to nan - comp.soft-sys.matlabBest Regards Sent details of data as following ... > > I try fill missing value with "nan" by wrote for example ... these zeros to NaN values so they would not show up ... "df" reports wrong size of filesystem - comp.unix.solaris ...Filling up missing data - comp.soft-sys.sas "df" reports wrong size of filesystem - comp.unix.solaris ..... posted the reason for this under the thread 'Missing ... Re: Question about read in Excel date data - comp.soft-sys.sas ...... of a secretarial pool were asked to help fill in ... treat the value with format dd/mm/yyyy >as >missing ... survival analysis: setting up longitudinal data question - comp ... Numbers formatted with leading zeros? - comp.databases.filemaker ...... so that it is always x number of digits with zeros filling ... Would have to line them up to look like one number. ... I _knew_ I was missing something ... in this case brain ... what command for checking physical disks or partitions not being ...What's missing? Is there a DBMS running that might be ... It's filling in for someone fun? -- DeeDee, don't press ... help : Analyzing MRI raw data - comp.dsp what command ... Zip data descriptor (bit 3 flag) - comp.compression... find a signature beginning a new header, then back up ... Is this just how zip files go, or am I missing a concept ... you can't seek in the output stream to go back & fill in ... griddata - NaN - comp.soft-sys.matlab... to do an interpolation between some experimental data ... (and v if it applies) In any case, up to some extent ... require a uniform grid, so any one ... replace missing ... Reading ASCII text file with variable number of columns - comp ...... data file name, others might have "n" data file names). I set it up ... to change it to a columnar format, and to fill ... way you go, whether you choose NaN for missing ... Filling up missing columns data - Microsoft Corporation: Software ...Hi, I have the following table : Code Block Create table #Customers (custid int,name nvarchar(20),age int, st_code int, citycode int, internalid int,type ... Filling up missing data - comp.soft-sys.sas | Computer GroupHello 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 missin... 7/24/2012 2:56:10 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
17 followers. 