SAS Training Sept 28 & 29 for UC Researchers

Exporting SAS Data Sets and Creating ODS Files for Microsoft Excel

This workshop presents the most effective techniques for exporting SAS tables or procedure output from Base SAS into Excel spreadsheets. The course uses examples to show the basics of the SAS Excel LIBNAME engine, the EXPORT procedure, and ODS to create CSV, HTML, and XML files that can be opened by Excel. You will learn how to use the EXPORT procedure to create Microsoft Excel files from SAS tables, use the LIBNAME engine to create Microsoft Excel files from SAS tables, use ODS to create comma-separated-values files and HTML files for Microsoft Excel, and use ODS to create Spreadsheet Markup Language files for Microsoft Excel. This is a hands-on workshop. This workshop is available to UC researchers only. RSVP here. Monday, September 28, 2015 from 9:00 - 4:00 pm in CLICC Classroom C (320 Powell Library).
 

SAS Functions by Example

Ever spent valuable time writing complex code only to later find a function that would have done the job for you? Discover the plethora of practical SAS functions that you haven't seen in other SAS programming courses, and start resolving your everyday programming problems more quickly and efficiently. You will learn how to magically manipulate character data with ease, using PERL Regular Expression (PRX) and other amazing character functions, dominate datetime, date, and time values with the previously perplexing Date Interval functions, save programming time and reduce programmer frustration with array functions, easily compute descriptive statistics, including how to use the new SMALLEST and LARGEST functions, use mathematical and special functions to streamline your code, generate random numbers with ease, and manipulate the values in various variables with the new CALL SORTN and CALL SORTC routines. This is a hands-on workshop. RSVP here. Tuesday, September 29, 2015 from 9:00 - 4:00 pm in CLICC Classroom C (320 Powell Library).
 

 

Tag: