Thomas Burgan

Thomas Burgan

Thomas Burgan
Senior Application Systems Programmer/Analyst
UVA Health System

How long have you been using SAS®?

34 years.

What SAS products have you used in the past? What products and solutions are you currently using?

Base SAS (Mainframe)

What is a problem you have solved using SAS?

I created monthly Clinic Activity reports for all outpatient clinics. These reports are distributed in RTF format.

I used Proc Report (BY CLINIC_NAME CLINIC_SITE), rendering an output file using the statement: ODS RTF FILE=CURTF1 STYLE=STYLES.CARS TRANTAB=ASCII BODYTITLE WORDSTYLE="{\s1 Heading 1;}" NOTOC_DATA.

The job that executes the SAS step FTPs the report to a shared network folder. Once the file is opened in MS Word, a table of contents is generated using a Word macro. For generating the individual clinic reports, a Word macro parses the RTF document with the table of contents into individual reports, saving them to files with names composed with the variables CLINIC_NAME and CLINIC_SITE.

What is the most innovative way you have used SAS?

The enterprise master data that is used for Clinic Activity reporting is maintained in an MS SQL Server database. While most of our ad hoc activity reporting is supported by a resource scheduling transaction repository located on an MS SQL Server, all of our monthly and quarterly activity and regulatory reporting is still executed on the mainframe.

The sources for these mainframe reports are SAS data sets, containing scheduling system transactions by fiscal year. A weekly download from our legacy Resource Scheduling System (Invision) maintains the records in these SAS data sets. The mainframe reporting SAS code uses user-defined formats derived from the information stored in the SQL Server master data database. Each time a master data table is changed (e.g., new scheduled resource, resource name change, etc.), a snapshot of this table is sent to a shared folder on an FTP server as a delimited text file. A nightly SAS job uploads these text files to the mainframe and updates (i.e., recreates) the SAS formats in a number of format libraries.

What is your most memorable SAS moment?

How has SAS changed in the time you have been using it?

How has SAS changed in the time you have been using it?

Well, my first SAS programs were submitted by giving punched card decks to operators to feed into the card reader. I am now able to create much more professional looking reports rendered in many different styles. What has been important for me is that nothing really has changed much with respect to code syntax rules, program structure, and the basic procedures used for reporting and analysis. I can take SAS code I wrote 35 years ago and run it today without error.

Have you ever attended a SAS users group meeting or SAS Global Forum? If yes, please list them.

I have never attended a SAS forum.

Has your work with SAS been influenced by any other members of the SAS community?

No, but I often use the papers presented at the forums for reference. I have a notebook containing reprints, many of which I have yet to read.

If you could point a new SAS user to one resource, what would it be?

Google

SAS Circle of Excellence - 30 years

SAS Milestones

Tell us your story

Fill out a short online survey, providing as much detail as you can. Select stories will be featured – we'll let you know if yours is one of them.

Questions?

Contact Buffie Silva

Back to Top