topic Re: Spreading the value across the column in New SAS User

Spreading the value across the column

hcbn — Tue, 12 Mar 2019 15:24:17 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: Spreading the value across the column

PeterClemmensen — Tue, 12 Mar 2019 15:48:17 GMT

One way

data have;
input qty EOQ;
datalines;
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
;

data want(drop=c temp);
   set have;
   Requested_Output=qty;
   if qty>0 then Requested_Output=qty;

   if qty=12 then do;
      Requested_Output=qty/EOQ;
      temp=Requested_Output;
      c=temp;
   end;

   if qty=0 and c<12 then do;
      c=c+temp;
      Requested_Output=temp;
   end;

   retain c temp;
run;

Re: Spreading the value across the column

hcbn — Tue, 12 Mar 2019 16:30:13 GMT

Thank you so much. It is working. I appreciate your help 🙂

Re: Spreading the value across the column

novinosrin — Tue, 12 Mar 2019 16:32:05 GMT

@hcbn Sorry Too late to notice your question, but whatever!!!

data have;
input qty	EOQ;
cards;
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
;
data want;
set have;
retain k q;
if qty>0 then do; q=qty;k1=0;end;
if qty=12 then  k=qty/EOQ;
k1+k;
k=ifn(q=12,(k1<=12)*k,qty);
drop k1 q;
run;

Re: Spreading the value across the column

hcbn — Thu, 14 Mar 2019 15:10:55 GMT

@novinosrinThank you so much to you as well

Re: Spreading the value across the column

hcbn — Thu, 14 Mar 2019 17:58:49 GMT

Sorry it does not correct accurately

Re: Spreading the value across the column

hcbn — Thu, 14 Mar 2019 17:59:30 GMT

@novinosrin this is working