Hello,

I try to measure investment efficiency in this paper "How does financial reporting quality relate to investment efficiency?"
I want to rank firms (Stkcd) into deciles based on their cash balance (CASH) and their leverage (LV) in each industry-year (Year Indcd), and rescale them to range between 0 and 1.
Moreover, if I want to get the above but using the whole sample (i.e., without industry-year level)



Stkcd Year Indcd LV CASH
000002 2013 K70 -.7799703 4.44e+10
000002 2014 K70 -.7720464 6.27e+10
000002 2015 K70 -.7770152 5.32e+10
000002 2016 K70 -.8053671 8.70e+10
000002 2017 K70 -.8398126 1.74e+11
000002 2018 K70 -.8458564 1.88e+11
000002 2019 K70 -.8435895 1.66e+11
000002 2020 K70 -.812835 1.95e+11
000004 2013 C27 -.4032394 5.65e+07
000004 2014 C27 -.5347545 3.99e+07
000004 2015 C27 -.5904017 5.15e+07
000004 2016 C27 -.2034563 1.01e+08
000004 2017 C27 -.3152466 1.06e+08
000005 2013 K70 -.474831 4.55e+07
000005 2014 K70 -.5099636 5.59e+07
000005 2015 K70 -.44704 1.63e+08
000005 2016 N77 -.4637085 7.64e+07
000005 2017 N77 -.5177473 8.71e+07
000005 2018 N77 -.4940399 6.77e+07
000005 2019 N77 -.4253374 1.12e+08
000005 2020 N77 -.4600894 1.38e+08
000006 2013 K70 -.5799717 2.05e+09
000006 2014 K70 -.6414202 1.36e+09
000006 2015 K70 -.6461508 1.78e+09
000006 2016 K70 -.6104992 2.91e+09
000006 2018 K70 -.5282363 3.65e+09
000006 2019 K70 -.5446121 3.04e+09
000006 2020 K70 -.4921853 1.95e+09
000007 2013 H61 -.4627542 2.26e+08
000007 2014 H61 -.4742944 7.47e+07
000007 2015 H61 -.2238475 2.19e+08
000007 2019 K70 -.6012611 7.90e+07
000007 2020 K70 -.8139322 5.12e+07
000008 2013 H61 -.1006048 1.46e+08
000008 2014 H61 -.1122762 1.83e+08
000008 2015 C37 -.1898092 4.50e+08
000008 2016 C37 -.2465831 1.12e+09
000008 2017 C37 -.3269488 1.01e+09
000008 2018 C37 -.2925097 1.23e+09
000008 2019 C37 -.3709616 1.30e+09
000008 2020 C37 -.4801671 7.78e+08
000009 2013 S90 -.6287978 1.61e+09
000009 2014 S90 -.6289341 1.99e+09
000009 2015 S90 -.6382021 3.84e+09
000009 2016 S90 -.623791 1.97e+09
000009 2017 S90 -.6331205 3.94e+09
000009 2018 S90 -.6498956 4.71e+09
000009 2019 S90 -.6455591 5.49e+09
000009 2020 S90 -.5842173 6.74e+09
000010 2013 C35 -.3581516 4.62e+08
000010 2014 C35 -.3141284 3.88e+08
000010 2015 E48 -.5795767 1.26e+09
000010 2016 E48 -.5447209 5.57e+08
000010 2017 E48 -.6201161 4.08e+08
000010 2018 E48 -.8195049 8.67e+07
000010 2019 E48 -.8243732 8.92e+07
000010 2020 E48 -.7695267 6.66e+07
000011 2013 K70 -.5343336 9.77e+08
000011 2014 K70 -.4656321 8.09e+08
000011 2015 K70 -.5203465 9.46e+08
000011 2016 K70 -.6376364 2.87e+09
000011 2017 K70 -.4581168 2.48e+09
000011 2018 K70 -.4259307 3.39e+09
000011 2019 K70 -.6967677 3.30e+09
000011 2020 K70 -.6902588 4.21e+09
000012 2013 C30 -.4428684 2.80e+08
000012 2014 C30 -.4429854 1.58e+08
000012 2015 C30 -.5116955 5.79e+08
000012 2016 C30 -.5259067 5.87e+08
000012 2017 C30 -.5505697 2.46e+09
000012 2018 C30 -.5056337 2.23e+09
000012 2019 C30 -.4579569 1.99e+09
000012 2020 C30 -.4063672 2.13e+09
000014 2013 K70 -.6494246 2.14e+08
000014 2014 K70 -.6766011 2.20e+08
000014 2015 K70 -.6438923 1.05e+08
000014 2017 K70 -.4764368 1.42e+08
000014 2018 K70 -.5043656 1.81e+08
000014 2019 K70 -.5153418 1.54e+08
000014 2020 K70 -.6080958 4.70e+08
000016 2013 C39 -.7281315 1.84e+09
000016 2014 C39 -.7438843 1.70e+09
000016 2015 C39 -.7841845 1.71e+09
000016 2016 C39 -.8075465 2.62e+09
000016 2017 C39 -.6520106 3.21e+09
000016 2018 C39 -.7134652 4.35e+09
000016 2019 C39 -.7669076 6.60e+09
000016 2020 C39 -.7850502 5.43e+09
000017 2013 C37 -.9491869 2.68e+07
000017 2014 C37 -.737887 3.02e+07
000017 2015 C37 -.7080773 2.68e+07
000017 2017 C37 -.7435973 2.80e+07
000017 2020 C37 -.720498 1.99e+07
000018 2013 C17 -.2693278 6.35e+07
000018 2014 C17 -.2976612 7.36e+07
000018 2015 C17 -.6812556 6.95e+08
000018 2016 E50 -.7707937 1.34e+09
000018 2017 E50 -.806291 1.60e+09
000018 2018 E50 -.9723466 6.59e+08
000019 2013 C15 -.2431128 2.58e+08