Convert the value to the spreading value

[hcbn]

Hello

I have a question.

If the value is equal to 12 then I need to divide the qty column to the EOQ column. The result will be spreading in the requested output until the total is 12. If the value less than 12 then I will keep it as it is.

Input
qty	EOQ
12	4
0	4
0	4
0	4
0	4
0	4
0	4
0	4
4	4
0	4
0	4
0	4
2	4
0	4
0	4
12	4
0	4
0	4
0	4
0	4
0	4
0	4
0	4

Output
qty	EOQ	Requested Output
12	4	3
0	4	3
0	4	3
0	4	3
0	4	0
0	4	0
0	4	0
0	4	0
4	4	4
0	4	0
0	4	0
0	4	0
2	4	2
0	4	0
0	4	0
12	4	3
0	4	3
0	4	3
0	4	3
0	4	0
0	4	0
0	4	0
0	4	0

[PeterClemmensen]

@hcbn please do not double post 🙂

See my solution at

https://communities.sas.com/t5/SAS-Programming/Convert-the-value-to-the-spreading-value/m-p/542429

[hcbn]

@PeterClemmensen  it was a mistake. I was trying to ask my question to new learners platform. I will be careful next time.

I can't see your reply. Please, share the correct link 

[PeterClemmensen]

Ah sorry, wrong link. There u go 🙂

https://communities.sas.com/t5/New-SAS-User/Spreading-the-value-across-the-column/m-p/542437