Hello and thanks for taking the time to help. I'm fairly new to using SAS, so don't have the best technical background. I'm running SAS EG with base 9.4, and am having to write some programs from scratch to get where I need to go. Here's my business scenario: I'm analyzing performance of ~6,000 individuals across a range of 18 measures. The measures reflect the most recent 13 weeks of performance, and are created weekly. My data is in the following format Name Type Length Format
Report_Week Date 8 MMDDYY10.
Alias Character 4
Role Character 32
Measure_1 Numeric 8
...
Measure_18 Numeric 8 I'm using Proc UNIVARIATE to calculate the 10th and 90th percentile, then splitting the interior range into 8 even buckets for a total of 10 buckets for each measure||Role||Report_Week. I then use Proc SQL to create the necessary formatting fields and Proc SORT to ensure they are in the correct order. The final set of buckets looks like this...(not including all 1440 rows) fmtname Start End Label SEXCY EEXCY HLO
$D2TCA020419A 0.00001 0.9879518072 < 98.80% N Y L
$D2TCA020419A 0.9879518072 0.9894578313 98.80% to 98.95% N Y
$D2TCA020419A 0.9894578313 0.9909638554 98.95% to 99.10% N Y
$D2TCA020419A 0.9909638554 0.9924698795 99.10% to 99.25% N Y
$D2TCA020419A 0.9924698795 0.9939759036 99.25% to 99.40% N Y
$D2TCA020419A 0.9939759036 0.9954819277 99.40% to 99.55% N Y
$D2TCA020419A 0.9954819277 0.9969879518 99.55% to 99.70% N Y
$D2TCA020419A 0.9969879518 0.9984939759 99.70% to 99.85% N Y
$D2TCA020419A 0.9984939759 0.9999 99.85% to 99.99% N Y
$D2TCA020419A 0.9999 1000000 > 99.99% Y Y H
$D2TCA021119A 0.00001 0.9879759519 < 98.80% N Y L
$D2TCA021119A 0.9879759519 0.9894789579 98.80% to 98.95% N Y
$D2TCA021119A 0.9894789579 0.9909819639 98.95% to 99.10% N Y
$D2TCA021119A 0.9909819639 0.9924849699 99.10% to 99.25% N Y I want to apply the labels to the dataset containing the actual results, but I get an error when trying to write in the format buckets: 229 proc format cntlin=localsbx.bucket_format;
ERROR: Start is greater than end: -.
230 run; I can't seem to figure out what I'm doing wrong. I've exported the bucket_format table to excel and tested the Start and End fields, verifying there are no cases where Start is greater than end. I've attached the full SAS code used to generate the buckets. Any assistance you can provide would be greatly appreciated, and if I'm going about this all wrong, I'm eager to learn how to do this "the right way". Thanks again, Frank
... View more
