topic Porting a function from Excel to SAS!!! in SAS Programming

Porting a function from Excel to SAS!!!

jacobwilliam — Thu, 20 Feb 2020 09:58:09 GMT

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?

Re: Porting a function from Excel to SAS!!!

LinusH — Thu, 20 Feb 2020 11:49:30 GMT

Even if you have quite a thorough description, please provide sample input data and desired output, just to make sure that we understand your need.

Re: Porting a function from Excel to SAS!!!

Reeza — Thu, 20 Feb 2020 16:26:08 GMT

Provide an example of what you have

Here are instructions on how to provide sample data as a data step:
https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

Show an example of what you need as output.

Show what you've tried.

Then we can help you connect the dots and get to where you want to go.

This question was also asked recently on here (last three months) so if you search on here you'll find some answers.