topic Re: Convert the value to the spreading value in SAS Programming

Convert the value to the spreading value

hcbn — Tue, 12 Mar 2019 15:17:05 GMT

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

Re: Convert the value to the spreading value

PeterClemmensen — Tue, 12 Mar 2019 15:52:08 GMT

@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

Re: Convert the value to the spreading value

hcbn — Tue, 12 Mar 2019 16:01:46 GMT

@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

Re: Convert the value to the spreading value

PeterClemmensen — Tue, 12 Mar 2019 16:03:43 GMT

Ah sorry, wrong link. There u go 🙂

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