I have high and low risk buckets of fees generated from 20 form types we have used over the years to charge customers for different services. Some forms are over two years old making them high risk for auditors. Fees change so revenue changes from year to year and we can process everything fast enough so there is a backlog. Forms less than two years or 1.5 years to the present are low risk. By employing a user defined format I assign a date interval as high risk and low risk for receipts and they get put into risk buckets accordingly, these are character variables. I have a coulmn for each form with high or low risk assigned as a character string.
PROBLEM: The fee column next door to the user defined character high or low risk columns is a numeric variable: fee.
When I go to put these in buckets in proc means the risk date format gets turned into number and anyhow I can't put fees in buckets for time interval risk. I need each user defined high or low risk record to attach to the fee amount and head for the right risk bucket.
Okay sages of SAS, where have I gone wrong????
... View more