San Diego SAS Users Group
  • Overview
    • Executive Committee
    • History
  • Courses
  • Meetings
    • Newsletter Blog
    • Newsletters
    • August 13, 2014 Meeting
    • SAS Classes - Posted 8/12/2013
    • March 13, 2013 Meeting
  • Links
  • Conferences
  • Jobs and Resume
    • Sr Clinical Data Programmer, Hologic, San Diego, CA - Posted on 04DEC2020
    • STATISTICIAN II /SENIOR STATISTICIAN /ASSOCIATE DIRECTOR, Ionis Pharmaceuticals, San Diego, CA - Posted on 28FEB2020
  • Books
  • Sponsors
  • Guestbook
Seminar #1: PROC SQL Programming: The Basics and Beyond 
by Kirk Paul Lafler
Thursday, September 12, 2013, 8:30am – 12:30pm (Please Register Soon - Seats are limited)
Embassy Suites La Jolla


This seminar teaches SAS users core concepts and features about accessing data stored in relational database tables. Attendees learn how to use PROC SQL to access data stored in relational tables; accomplish essential programming tasks including retrieving, subsetting, ordering, and grouping data; construct logic scenarios with case expressions; construct “virtual” tables known as views; explore one-to-one, one-to-many, many-to-one, and many-to-many data relationships; understand the similarities and differences between DATA step merges and joins; create complex queries using inner and outer join constructs as well as with set operators; use summary (statistical) functions to aggregate data; create new tables; produce “quality” looking output using PROC SQL options and Output Delivery System (ODS); interface PROC SQL with the macro facility to create single-value and multi-value (list) macro variables; understand basic index rules and strategies; and apply “select” query performance tuning techniques. 

Intended Audience: All SAS and SQL users
Prerequisites: SAS Essentials course or 6-months SAS software experience
Delivery Method: Instructor-led with code examples
Seminar Material: Seminar Notes are provided 


For more information, please access http://www.pharmasug.org/sde2013.html

Also Available

CDISC 101: Mapping SDTM and ADAM Variables
Sunil Gupta
Thursday, September 12, 2013, 1:30pm – 5:30pm
Embassy Suites La Jolla

http://www.pharmasug.org/sde2013.html

This seminar teaches SAS programmers essential concepts about creating and validating SDTM and ADaM variables in key CDISC datasets (DM, AE, LB, ADSL, ADAE, and ADLB). Attendees learn how to create and process ISO8601 dates, hierarchy of adverse events variables, paired lab variables, as well as lab visit window techniques. Specifically, you will learn how to apply programming techniques to convert between character and numeric ISO8601 date variables, to convert between character and numeric lab result values and units and to calculate the study day variable --DY, for example. Finally, you will also learn how to work with controlled terminology files and create the corresponding SUPP-- datasets to store extra domain and --SEQ variables.  

 


Powered by Create your own unique website with customizable templates.