Hi
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
Moh 3
Moh 3
Raj 4
Raj 4
Raj 4
Raj 4
I am not able to think how can I approach this problem. Any hints are welcome
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;
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;
Thanks a lot. It worked
Do you always have to specify the values in "Window"? Can this be modified for the case with lots of names?
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 .
OK thanks, In the datalines argument Moh and Raj have been specified. Can these be done 'on the fly'?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.