tricky sum
in [SAS]
|
Prev: 1)if and if-else 2)if and where 3)keep=option and keep statement4)input function and input statement 5)scan and substr6)if and if then do7)informat and format i had good knowledge about those difference with examples.
Next: Spectral Analysis
From: data _null_; on 26 Feb 2010 07:07 On Feb 26, 4:58 am, ChrisG <chris.godlew...(a)gmail.com> wrote: > > do you have any clue to solve that problem ? You posted this.... 4 9 0 0 0 0 0 35 4 7 8 0 0 0 0 32 4 4 3 1 0 0 0 19 4 5 6 4 0 0 0 2 4 2 6 7 0 0 0 2 4 8 9 7 2 0 0 2 I this the result you "expect"? 4 9 0 0 0 0 0 35 4 7 8 0 0 0 0 32 4 4 3 1 0 0 0 19 4 5 6 4 0 0 0 2 4 2 6 7 0 0 0 0 4 8 9 7 2 0 0 0
From: ChrisG on 26 Feb 2010 07:21 On 26 fév, 13:07, "data _null_;" <datan...(a)gmail.com> wrote: > On Feb 26, 4:58 am, ChrisG <chris.godlew...(a)gmail.com> wrote: > > > > > do you have any clue to solve that problem ? > > You posted this.... > > 4 9 0 0 0 0 0 35 > 4 7 8 0 0 0 0 32 > 4 4 3 1 0 0 0 19 > 4 5 6 4 0 0 0 2 > 4 2 6 7 0 0 0 2 > 4 8 9 7 2 0 0 2 > > I this the result you "expect"? > > 4 9 0 0 0 0 0 35 > 4 7 8 0 0 0 0 32 > 4 4 3 1 0 0 0 19 > 4 5 6 4 0 0 0 2 > 4 2 6 7 0 0 0 0 > 4 8 9 7 2 0 0 0 hi actually i need the data NEED i posted with the "2" 3 times as in the example CG
From: data _null_; on 26 Feb 2010 07:36 On Feb 26, 6:21 am, ChrisG <chris.godlew...(a)gmail.com> wrote: > On 26 fév, 13:07, "data _null_;" <datan...(a)gmail.com> wrote: > > > > > > > On Feb 26, 4:58 am, ChrisG <chris.godlew...(a)gmail.com> wrote: > > > > do you have any clue to solve that problem ? > > > You posted this.... > > > 4 9 0 0 0 0 0 35 > > 4 7 8 0 0 0 0 32 > > 4 4 3 1 0 0 0 19 > > 4 5 6 4 0 0 0 2 > > 4 2 6 7 0 0 0 2 > > 4 8 9 7 2 0 0 2 > > > I this the result you "expect"? > > > 4 9 0 0 0 0 0 35 > > 4 7 8 0 0 0 0 32 > > 4 4 3 1 0 0 0 19 > > 4 5 6 4 0 0 0 2 > > 4 2 6 7 0 0 0 0 > > 4 8 9 7 2 0 0 0 > > hi > > actually i need the data NEED i posted with the "2" 3 times as in the > example > > CG- Hide quoted text - > > - Show quoted text - OK but what about ID_BB=3 you show 0 but I don't see what makes ID3 different from ID4. 3 4 0 0 0 0 0 11 3 2 8 0 0 0 0 14 3 5 6 0 0 0 0 0
From: ChrisG on 26 Feb 2010 07:39 On 26 fév, 13:36, "data _null_;" <datan...(a)gmail.com> wrote: > On Feb 26, 6:21 am, ChrisG <chris.godlew...(a)gmail.com> wrote: > > > > > On 26 fév, 13:07, "data _null_;" <datan...(a)gmail.com> wrote: > > > > On Feb 26, 4:58 am, ChrisG <chris.godlew...(a)gmail.com> wrote: > > > > > do you have any clue to solve that problem ? > > > > You posted this.... > > > > 4 9 0 0 0 0 0 35 > > > 4 7 8 0 0 0 0 32 > > > 4 4 3 1 0 0 0 19 > > > 4 5 6 4 0 0 0 2 > > > 4 2 6 7 0 0 0 2 > > > 4 8 9 7 2 0 0 2 > > > > I this the result you "expect"? > > > > 4 9 0 0 0 0 0 35 > > > 4 7 8 0 0 0 0 32 > > > 4 4 3 1 0 0 0 19 > > > 4 5 6 4 0 0 0 2 > > > 4 2 6 7 0 0 0 0 > > > 4 8 9 7 2 0 0 0 > > > hi > > > actually i need the data NEED i posted with the "2" 3 times as in the > > example > > > CG- Hide quoted text - > > > - Show quoted text - > > OK but what about ID_BB=3 you show 0 but I don't see what makes ID3 > different from ID4. > > 3 4 0 0 0 0 0 11 > 3 2 8 0 0 0 0 14 > 3 5 6 0 0 0 0 0 .... sorry you are right i didn't check the data from the person who prepared it... shame on me in that case we need this : > 3 4 0 0 0 0 0 11 > 3 2 8 0 0 0 0 14 > 3 5 6 0 0 0 0 14 CG
From: data _null_; on 26 Feb 2010 07:57
On Feb 26, 6:39 am, ChrisG <chris.godlew...(a)gmail.com> wrote: > On 26 fév, 13:36, "data _null_;" <datan...(a)gmail.com> wrote: > > > > > > > On Feb 26, 6:21 am, ChrisG <chris.godlew...(a)gmail.com> wrote: > > > > On 26 fév, 13:07, "data _null_;" <datan...(a)gmail.com> wrote: > > > > > On Feb 26, 4:58 am, ChrisG <chris.godlew...(a)gmail.com> wrote: > > > > > > do you have any clue to solve that problem ? > > > > > You posted this.... > > > > > 4 9 0 0 0 0 0 35 > > > > 4 7 8 0 0 0 0 32 > > > > 4 4 3 1 0 0 0 19 > > > > 4 5 6 4 0 0 0 2 > > > > 4 2 6 7 0 0 0 2 > > > > 4 8 9 7 2 0 0 2 > > > > > I this the result you "expect"? > > > > > 4 9 0 0 0 0 0 35 > > > > 4 7 8 0 0 0 0 32 > > > > 4 4 3 1 0 0 0 19 > > > > 4 5 6 4 0 0 0 2 > > > > 4 2 6 7 0 0 0 0 > > > > 4 8 9 7 2 0 0 0 > > > > hi > > > > actually i need the data NEED i posted with the "2" 3 times as in the > > > example > > > > CG- Hide quoted text - > > > > - Show quoted text - > > > OK but what about ID_BB=3 you show 0 but I don't see what makes ID3 > > different from ID4. > > > 3 4 0 0 0 0 0 11 > > 3 2 8 0 0 0 0 14 > > 3 5 6 0 0 0 0 0 > > ... > sorry > you are right > i didn't check the data from the person who prepared it... > shame on me > in that case we need this : > > > 3 4 0 0 0 0 0 11 > > 3 2 8 0 0 0 0 14 > > 3 5 6 0 0 0 0 14 > > CG- Hide quoted text - > > - Show quoted text - In Mikes program change.... (keep=id_bb col1 rename=(col1=x) index=(id_bb)); to (keep=id_bb col1 rename=(col1=x) index=(id_bb) where=(x gt 0)); This will shorten the transposed data, it assumes that all zeros are "to the right in the D array" of all non zero sums. If that is not true you will need a bit more "logic". When the "next" value in the KEYed assess set is not found the value of X will be unchanged from the last itteration of the data step. You will get two 14s and three 2s. I believe this is the same result you would obtain by merging BY ID_BB where the merge has "more than one data set set with repeats of the by variable". |