For 002, you have 3 extra pills from day1-day3, but you only use 2 to fill the gap (day 4,6), why the 3rd one is not used for day7?

On Wed, 21 Apr 2010 09:07:52 -0700, Mary <mlhoward@AVALON.NET> wrote:

>Joe, > >Yes, it is straighforward- just didn't do my example that well. Here it is again- > >data test2; >infile cards missover; >input id day1 day2 day3 day4 day5 day6 day7 day8 day9 day10 day11 day12; >cards; >001 1 1 1 1 2 2 . . . . 1 1 >002 2 2 2 . 1 . . . . . 1 . >; >run; > >These are the number of pills someone has on hand each day. What I want is to fill in the gaps with the extra pills on hand, so I want a result like this: > >001 1 1 1 1 1 1 1 1 . . 1 1 >002 1 1 1 1 1 1 . . . . 1 . > >Ideas would be appreciated; I'd like to keep this wide rather than transpose it long if possible. > > >-Mary > > >--- snoopy369@gmail.com wrote: > >From: Joe Matise <snoopy369@gmail.com> >To: mlhoward@avalon.net >Cc: SAS-L@listserv.uga.edu >Subject: Re: Filling in Gaps? >Date: Wed, 21 Apr 2010 11:04:30 -0500 > >Mary, just so I understand, can you take a quick look at the data you >posted? I see twelve days not ten, and I don't understand how you decided >to fill in some gaps and not others on ID #2 (it looks like you have at >least one extra pill). Is this a straightforward 'fill forward' problem, or >is there anything else going on? > >Thanks, > >Joe > >On Wed, Apr 21, 2010 at 11:10 AM, Mary <mlhoward@avalon.net> wrote: > >> Hi, >> >> I've got a data set like this: >> >> data test2; >> infile cards missover; >> input id day1 day2 day3 day4 day5 day6 day7 day8 day9 day10; >> cards; >> 001 1 1 1 1 2 2 . . . . 1 1 >> 002 2 2 2 . 1 . . . . . 1 . >> ; >> run; >> >> These are the number of pills someone has on hand each day. What I want is >> to fill in the gaps with the extra pills on hand, so I want a result like >> this: >> >> 001 1 1 1 1 1 1 1 1 . . 1 1 >> 002 1 1 1 1 1 1 . . . . 1 . >> >> Ideas would be appreciated; I'd like to keep this wide rather than >> transpose it long if possible. >> >> -Mary >>