topic Re: Spreading the values based on restriction in New SAS User https://communities.sas.com/t5/New-SAS-User/Spreading-the-values-based-on-restriction/m-p/543249#M7669 <P>@<A href="https://communities.sas.com/t5/user/viewprofilepage/user-id/138205" target="_blank" rel="noopener">novinosrin</A><SPAN>&nbsp; Do you have any idea?&nbsp;</SPAN>For each dest id in the column, the desired output will be renewed. Thank you.</P> Thu, 14 Mar 2019 16:52:51 GMT hcbn 2019-03-14T16:52:51Z Spreading the values based on restriction https://communities.sas.com/t5/New-SAS-User/Spreading-the-values-based-on-restriction/m-p/543224#M7665 <P>Hi</P><P><SPAN>If the value is equal to 12 in the qty column 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. Please, look at the value the qty column. The dest id column is also an indication. The restriction is based on the dest id column.&nbsp;</SPAN></P><TABLE><TBODY><TR><TD>Input</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>dest_id</TD><TD>qty</TD><TD>EOQ</TD></TR><TR><TD>13690</TD><TD>12</TD><TD>2</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD></TR><TR><TD>13690</TD><TD>12</TD><TD>2</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>12</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>12</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD></TR><TR><TD>13827</TD><TD>12</TD><TD>3</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Desired Output</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>dest_id</TD><TD>qty</TD><TD>EOQ</TD><TD>Desired Output</TD></TR><TR><TD>13690</TD><TD>12</TD><TD>2</TD><TD>6</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD><TD>6</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD><TD>0</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD><TD>0</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD><TD>0</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD><TD>0</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD><TD>0</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD><TD>0</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD><TD>0</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD><TD>0</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD><TD>0</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD><TD>0</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD><TD>0</TD></TR><TR><TD>13690</TD><TD>0</TD><TD>2</TD><TD>6</TD></TR><TR><TD>13690</TD><TD>12</TD><TD>2</TD><TD>6</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>0</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>0</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>0</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>0</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>0</TD></TR><TR><TD>13827</TD><TD>12</TD><TD>3</TD><TD>4</TD></TR><TR><TD>13827</TD><TD>12</TD><TD>3</TD><TD>4</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>4</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>4</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>4</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>4</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>0</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>0</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>0</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>0</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>0</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>0</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>0</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>4</TD></TR><TR><TD>13827</TD><TD>0</TD><TD>3</TD><TD>4</TD></TR><TR><TD>13827</TD><TD>12</TD><TD>3</TD><TD>4</TD></TR></TBODY></TABLE> Thu, 14 Mar 2019 15:44:26 GMT https://communities.sas.com/t5/New-SAS-User/Spreading-the-values-based-on-restriction/m-p/543224#M7665 hcbn 2019-03-14T15:44:26Z Re: Spreading the values based on restriction https://communities.sas.com/t5/New-SAS-User/Spreading-the-values-based-on-restriction/m-p/543249#M7669 <P>@<A href="https://communities.sas.com/t5/user/viewprofilepage/user-id/138205" target="_blank" rel="noopener">novinosrin</A><SPAN>&nbsp; Do you have any idea?&nbsp;</SPAN>For each dest id in the column, the desired output will be renewed. Thank you.</P> Thu, 14 Mar 2019 16:52:51 GMT https://communities.sas.com/t5/New-SAS-User/Spreading-the-values-based-on-restriction/m-p/543249#M7669 hcbn 2019-03-14T16:52:51Z