About sunny86

sunny86 · ‎06-17-2023

@ballardw What i am trying to achieve is I have 5 departments and i have to assign the 649 observations to the groups in such a way that the variance between the groups is minimal for both balance and score. I tried with balance of reverse sequence Data want; do i = 1 to &Dep; set Sample (keep=Department Score Balance Uniq_no) end=done; group = i; output; end; do i = &Dep to 1 by -1 until(done); set Sample (keep=Department Score Balance Uniq_no) end=done; group = i; output; end; drop i;

sunny86 · ‎06-17-2023

@ballardw I have a datset of 649 observations i want to alternate the sequence in descending order. I am sorting the dataset in descending order and i want to assing the balances to the 5 groups such that the average balance across the groups will be close to similar I am achieving it by assigning the balances to groups So in the example dataset I want to alternate the Groups In the first iteration the sequence went from 1 to 5 and then next iteration it should assign from 5 to 1

sunny86 · ‎06-17-2023

@mkeintz the output I ma expecting is to reverse the sequence alternatively Form your suggestion i got the below output but what i want is to reverse it 1 6000 1 2 5600 2 3 5500 3 4 5300 4 5 5200 5 6 5200 1 7 5100 2 8 5000 3 9 4800 4 10 4500 5 Expected 1 6000 1 2 5600 2 3 5500 3 4 5300 4 5 5200 5 6 5200 5 7 5100 4 8 5000 3 9 4800 2 10 4500 1

sunny86 · ‎06-17-2023

data have; input Balance; datalines; 5000 6000 5500 4500 5200 4800 5100 5600 5200 5300 ; run; proc sort data=have; by descending Balance; run; data result; do i= 1 to 5, 5 to 1 until(done); set have end=done; group = i; output; end; drop i; run; My output 1 6000 1 2 5600 2 3 5500 3 4 5300 4 5 5200 5 6 5200 1 7 5100 2 8 5000 3 9 4800 4 10 4500 5 Expected output 1 6000 1 2 5600 2 3 5500 3 4 5300 4 5 5200 5 6 5200 5 7 5100 4 8 5000 3 9 4800 2 10 4500 1

Online Status	Offline
Date Last Visited	‎06-18-2023 12:04 PM

Re: Read balances (in decreasing order) and assign them to groups alte...

Re: Read balances (in decreasing order) and assign them to groups alte...

Re: Read balances (in decreasing order) and assign them to groups alte...

Read balances (in decreasing order) and assign them to groups alternat...

Re: Read balances (in decreasing order) and assign them to groups alte...

Re: Read balances (in decreasing order) and assign them to groups alte...

Re: Read balances (in decreasing order) and assign them to groups alte...

Read balances (in decreasing order) and assign them to groups alternat...