Health Intelligence Consultant
APS Healthcare / Universal American
Nina Werner graduated from Barnard College, Columbia University, and earned her MBA from Pace University in New York. After spending nearly two decades working in New York City, Werner relocated to Madison, WI, where she worked for a major physician-owned health plan for over a decade. She currently works for a Fortune 500 company that does health analytics management. She has attended and presented at local, regional and global SAS conferences and is well-recognized in the SAS community in Madison.
How long have you been using SAS®?
What SAS products have you used in the past? What products and solutions are you currently using?
Used in past: Base SAS, SAS/STAT®, SAS macro language, SAS/ETS®, SAS/CONNECT®, SAS/ACCESS® Interface to Oracle, SAS/ACCESS® Interface to Sybase IQ, ODBC, SAS® Enterprise Guide® on IBM mainframes, Unix [Reflections and X-Windows] and Windows servers and PCs.
Currently use: Only Base SAS, SAS/STAT, SAS macro language, ODBC, SAS Enterprise Guide on PC.
What is a problem you have solved using SAS?
I presented at SUGI 25 about maintaining the GCHART scales from one page to another for a BY group and resetting for the next BY group using macro variables. Since HTML has variable page size, the problem of multiple pages with unequal scales within a BY group is moot. I created a reporting process using a macro loop to write several thousand individual single-page reports, containing individual targets and actual and summary results tables and graphs, to separate directories, so each recipient can only see his own result.
What is the most innovative way you have used SAS?
I use Base SAS as an ETL tool to clean up unprintable characters and dates and load data to MS SQL Server tables. Here is code to create a SQL Server datetime from SAS date:
load_date = %sysfunc(inputn(%sysfunc(putn(%sysfunc(
dhms(%sysfunc(inputn(&sysdate,date7.)),0,0,0)),datetime.)), datetime.)) ;
I used to schedule CLEANWORK jobs on my PC SAS using a rudimentary VBscript. This is no longer necessary to run. I use multiple Config files to open SAS for special projects and users. I wrote a couple of macros for the health plan to encrypt, store and retrieve RDBMS userid and password so LIBNAME statements will not have values hard-coded. They are currently being used at another local company after I shared the code.
What is your most memorable SAS moment?
Ten years ago, I presented at the WI-IL-SUG about less-used options of PROC SUMMARY, and another speaker and well-known SAS author, Ron Cody, was kind enough to say that he learned something new from my talk.
How has SAS changed in the time you have been using it?
SAS has always been responsive to its users, adding features which are most requested by the SASware Ballot®. The software has expanded, but this attitude has not changed.
There was no PROC LOGISTIC when I started using SAS, but there was PROC EXPLODE. :-)
Have you ever attended a SAS users group meeting or SAS Global Forum? If yes, please list them.
SUGI 11, 12, 18, 25, 31 and many NYASUG in the ’80s, WI-IL-SUG and WISUG since '91 and a couple of Midwest SUG. I wish I were able to attend SAS Global Forum.
Has your work with SAS been influenced by any other members of the SAS community?
I have to name LeRoy Bessler as a mentor over the past 20 years. He encouraged me to participate and speak to local groups and SUGI. I enjoyed being one of the early participants in NYASUG with Ray Pass and Ron Cody. I read papers from many authors in the Books by Users catalog.
If you could point a new SAS user to one resource, what would it be?
I point my new SAS users to Lex Jansen’s search but tell them to feel free to call me with SAS questions.