SAS Enterprise Guide 2: Advanced Tasks & Querying
9:00am to 5.00pm
S$1,800 (excl of G.S.T)
|2021 Course Dates
22 – 23 Feb 2021
15 – 16 Mar 2021
22 – 23 Jun 2021
|None of the published dates will work for you? Speak to our training consultants for a private tuition arrangement or a closed door training.|
This course is intended for experienced SAS Enterprise Guide users who want to learn more about advanced SAS Enterprise Guide techniques. It focuses on using the Query Builder within SAS Enterprise Guide, including manipulating character, numeric, and date values; converting variable type; and building conditional expressions using the Expression Builder. This course also addresses efficiency issues, such as joining tables and using a single query to group, summarize, and filter data.
Learn how to
• Use tasks to transpose, stack, rank, and create a random sample of your data.
• Use functions to convert the data type from character to numeric and from numeric to character.
• Use conditional logic in the Query Builder to create new columns.
• Use multiple value prompts.