topic Multiply rows base on values in field in SAS Programming

Multiply rows base on values in field

bnarang — Tue, 03 Nov 2015 08:22:28 GMT

Please help me with below problem. I need to multiply rows based on the value in the field. For example my data like this below:

Name Window

Moh 3

Raj 4

I would like my output to be mulitplied w..r.t window

Name Window

Moh 3

Raj 4

I am not able to think how can I approach this problem. Any hints are welcome

Re: Multiply rows base on values in field

pearsoninst — Tue, 03 Nov 2015 08:34:33 GMT

data newdata; 
Window = Window; 
input Name$ Window; 
do i = 1 to Window; 
output; 
end; 
datalines; 
Moh 3 
Raj 4 
; 
run;
Proc Print data = newdata;
run;

Re: Multiply rows base on values in field

bnarang — Tue, 03 Nov 2015 08:36:50 GMT

Thanks a lot. It worked

Re: Multiply rows base on values in field

pearsoninst — Tue, 03 Nov 2015 08:37:51 GMT

welcome

Re: Multiply rows base on values in field

David2 — Tue, 17 Nov 2015 10:36:09 GMT

Do you always have to specify the values in "Window"? Can this be modified for the case with lots of names?

Re: Multiply rows base on values in field

pearsoninst — Tue, 17 Nov 2015 14:09:53 GMT

Window = Window; it will calculate the number you have specified in the the variable window.
So Moh has 3 window so when do loop start i will take 3 (i = 1 to 3 )with the first obs which is raj and then 
i will take 4 (i = 1 to 4 ) and the window value in Raj has 4 . And it will work with lots of names .

Re: Multiply rows base on values in field

David2 — Tue, 17 Nov 2015 14:51:33 GMT

OK thanks, In the datalines argument Moh and Raj have been specified. Can these be done 'on the fly'?