SAS Customer Recognition — Robert G. Smith
Robert G. Smith
Financial Advisor/Computer Systems Analyst
TE Connectivity Ltd.
How long have you been using SAS?
For the last 17 of my 30 years in information technology.
What SAS products have you used in the past and what products and solutions are you currently using?
Current: Base SAS, SAS/ACCESS for Oracle.
Past: SAS/ACCESS for PC File Formats, SAS/AF.
What is a problem you have solved using SAS?
Automating jobs that merge disparate data sources (Oracle tables, tab-delimited text files, IBM mainframe CICS transaction output, EDI transaction data, etc.).
What is the most innovative way you have used SAS?
I built an entire automated report generation and delivery system with SAS as the centerpiece, and have upgraded it over the years as new technologies have been introduced. It has hooks into plenty of third-party tools: VBScript, Excel VBA macro code, native Oracle queries with run-time parameters generated by SAS, DOS commands, Microsoft SharePoint, Oracle bulkloading, and Tivoli job scheduling.
I have also used SAS to build the infrastructure of Web applications, including the target Oracle tables, HTML SELECT options lists, and management of application availability during table refresh periods.
What is your most memorable SAS moment?
I used SAS to build transactions to pass to Ericom PowerTerm, a mainframe terminal emulation product, to invoke CICS to simulate keyboard entry and grab information not held in a database store directly from the screen.
How has SAS changed in the time you have been using it?
It has matured from a mainframe product to one that handles many different operating environments and file formats.
Has your work with SAS been influenced by any other members of the SAS Community?
I have been influenced mostly by my co-workers.
If you could point a new SAS user to one resource, what would it be?
I would make sure they know about Base SAS and SAS/ACCESS documentation. In the current world of business analytics involving mounds of information, SAS does an admirable job of processing logic in a time-sensitive manner.