Skip links

Main navigation

Loading Events
Find Events

Upcoming Events

Events List Navigation

September 2015

Exporting SAS Data Sets and Creating ODS Files for Microsoft Excel

September 28 @ 9:00 am - 4:00 pm
IDRE Portal (5628 Math Science Building),
UCLA

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…

Find out more »

SAS Functions by Example

September 29 @ 9:00 am - 4:00 pm
CLICC Classroom C,
320 Powell Library

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…

Find out more »
+ Export Listed Events

Events List Navigation

UCLA Office of Information and Technology