Location:
Henrico County Public Library – Glen Allen
10501 Staples Mill Rd, Glen Allen, VA 23060
Time
March 15 2:30pm to 5:00pm
AGENDA
2:30 – 3:00 Meet and Greet
3:00 – 4:00 Challenges and Solutions when Using SAS ® to Process Large Data Sets – Mark Jordan, SAS
Learn how to perform the following tasks:
o use SAS system options to evaluate query efficiency
o tune SAS programs to improve big-data performance
o modify SQL queries to maximize implicit pass-through
o re-architect processes to improve performance
o identify situations where data precision could be degraded
o leverage FedSQL and DS2 for:
– parallel processing on the SAS ® Platform for improved performance
– full-precision calculations with ANSI data types
– In-database processing with the SAS ® In-Database Code Accelerator
Take advantage of SAS ® Viya ® and SAS ® Cloud Analytic Services
(CAS) for fast distributed processing
Mark Jordan (a.k.a. SAS Jedi) grew up in northeast Brazil as the son of Baptist missionaries. He served 20 years as a US Navy submariner, pursuing his passion for programming as a hobby. Upon retiring from the Navy, he turned his hobby into a dream job, working as a SAS programmer for 9 years in
manufacturing and financial services before coming to SAS Institute in 2003. Mark teaches a broad spectrum of Foundation SAS programming classes and has authored several SAS training courses as well as a book titled Mastering the SAS Ds2 Procedure: Advanced Data Wrangling Techniques. When he isn’t teaching, Mark sporadically posts Jedi SAS Tricks on the SAS Training Post blog, and enjoys playing with his grandchildren and great-grandchildren, hanging out at the beach, and reading science fiction novels. His secret obsession is flying toys – kites, rockets, drones – and though he tries to
convince his wife they are for the grandkids, she isn’;t buying it. Mark currently lives in Toano, VA with his wife, Lori, and their cat, the amazing Tiger Man. You can find his blog at http://sasjedi.tips and follow him
on Twitter @SASJedi.
4:05 – 4:35
Efficiently Reading in and Conforming Large Numbers of Big Data Columns Using SAS (concept and SAS coding tutorial)
The topic looks at the following
o Use the SAS dictionary table to work with column metadata
o Transpose an odd data set to create the desired data structure
o SAS string manipulation (tranward, propcase, lowcase, trim, strip, find)
o Macro tricks that save time
David Phillips is an Enterprise Data Architect at Virginia Commonwealth University. He has 12 years of professional experience in many areas of data including: Data architecture, big data, analytics, and data administration. His focus at Virginia Commonwealth University is architecting an integrated academic data environment and optimizing analytics. He has a MS in Information Systems from Virginia Commonwealth
University and certified Microsoft DBA, certified Base SAS Programmer, and a background in six programming languages. Outside of the data world, he dances socially twenty hours a week.
Virginia SAS Users Group 
Leave a Reply