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.
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.