Name,Interval ,Intvl,Defin,Rolling, ,4hr Cap% ,Inter,Capping,Durati, ----,Date------,Time-,Capac,4hr MSU, ,0{50}100 , MSU, WLM% ,Cappin, PROD,29JUL2017 ,22:30, 57, 23, 40.6,***** , 26, N/A , N/A , PROD,29JUL2017 ,22:45, 57, 24, 41.9,***** , 18, N/A , N/A , This is the current output when using Excel: Average MSU 24.61 % > 40 MSU: 20.32% % > 45 MSU: 12.43% % > 48 MSU: 8.97% % > 50 MSU: 6.72% Peak MSU 68 % intervals > 75 % of cap 24.62% % intervals > 80 % 18.71% % intervals > 90 % 9.34% % intervals ≥ 100 % 0.97% % intervals capped 0.57% # Intrvls ≥ 60 MSUs 39 I am new to SAS so I really dont have much in terms of code.
... View more