CC06 Simplifying SASŪ Security     Contributed

Derek Morgan Division of Biostatistics, Washington University Medical School ,Dr. Michael Province
Division of Biostatistics, Washington University Medical School
Abstract: An increased emphasis on the security of data within the organization has led to the use of the security built into the SASŪ System. The encryption and passwording of the datasets used for this project was relatively easy to accomplish. However, day-to-day uses of this data range from analysis to data entry to ad hoc query. How do we allow all the different users access without hard coding the passwords, or forcing them to continually type in passwords? By using macro variables to carry the passwords.

Biography:
Derek is a Database Administrator in the Division of Biostatistics at Washington University School of Medicine. His areas of expertise include Base SAS, SAS/FSP, SCL, macro language and SAS/AF. He designs, develops and supports data entry/management system s for medical research as well as directing and implementing the compilation and documentation of data for several collaborative studies. He also teaches the basics of reading raw data with the SASŪ System in a university-sponsored hands-on seminar several times a year. He has been using the SAS System to process raw data in many different formats for over 15 years. Derek has won two "Best Speaker" awards at MidWest SAS Users Group conferences and has also received two honorable mentions at SUGI. He is curr ently the president of the MidWest SAS Users Group Board of Directors.

Dr. Province is an Associate Professor in the Division of Biostatistics at Washington University School of Medicine. He has lived in SAS for the past 20 years, having developed and directed the development of many a SAS program for data entry, management a nd analysis. He is currently the Principal Investigator for the coordinating center of the Family Heart Study, a multi-center observational study of the genetics of heart disease, as well as being heavily involved in other large studies.