Hi all- I'm fairly new to SAS, and I'm working on migrating over one of my daily reports for my job. When I came in, this report was done entirely in Excel and it was honestly kind of a nightmare to put together. My goal right now is to get it so 100% of the data processing is done in SAS, and I'm just about there. The only thing that's getting in the way is this one particular variable that's determined in a very Excel-specific way.
The report I run is essentially to determine how often our employees are answering customer phone calls they receive, and the raw data is a list of every phone call processed through our region (once the data gets filtered down, we're usually looking at just under 20,000 lines of data). The variable in question is the end time of the last phone call the employee received, which is used to determine whether or not the employee was on the phone at the time a phone call came in (so this way missing that call isn't held against them). Right now, the list is sorted by employee, then date/time of call- and Excel will simply pull down the end time of the call above. It certainly works, but my ultimate goal is to store the data somewhere like Access- and having anything still done in Excel would add a step to the process.
How would you all go about this?
