Transcription of Conditional Processing in EG - SAS
1 C op yr i g h t 2 0 1 3 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d . PROCESSINGIN ENTERPRISE GUIDE_____Judy Orr Lawrence SAS Training Specialist op yr i g h t 2 0 1 3 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d .AGENDAUses of Conditional Processing Create New Variables Control Task ExecutionApplying Conditional Processing Recode Values using Query Builder Case Statements Add Conditions to TasksENTERPRISE GUIDECONDITIONAL Processing C op yr i g h t 2 0 1 3 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d .CONDITIONALPROCESSING CREATE NEW VARIABLESQ uery Builder ~ Computed Column ~ Recode C op yr i g h t 2 0 1 3 , S A S I n s t i t u t e I n c.
2 A l l r i g h t s r es er v e d .CONDITIONALPROCESSING CREATE NEW VARIABLESR ecode ~ Discrete Values IFTHENC op yr i g h t 2 0 1 3 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d .CONDITIONALPROCESSING CREATE NEW VARIABLESR ecode ~ Range of Values IFTHENC op yr i g h t 2 0 1 3 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d .CONDITIONALPROCESSING CREATE NEW VARIABLESR ecode ~ Based on a ConditionIFTHENE xtensive list of operatorsAdvanced Expression EditorC op yr i g h t 2 0 1 3 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d .Case StatementCONDITIONALPROCESSING CREATE NEW VARIABLESEG CreatedManuallyCreatedC op yr i g h t 2 0 1 3 , S A S I n s t i t u t e I n c.
3 A l l r i g h t s r es er v e d .CONDITIONALPROCESSING CONTROL TASK EXECUTIONC op yr i g h t 2 0 1 3 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d .CONDITIONALPROCESSING CONTROL TASK EXECUTIONIFTHENC ondition can be based on:-Dataset value-Date / Time value-Prompt value-Macro variable valueC op yr i g h t 2 0 1 3 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d .DEMOC op yr i g h t 2 0 1 3 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d . Enterprise Guide 1: Querying and Reporting SAS Enterprise Guide for Experienced SAS Programmers SAS Enterprise Guide 2: Advanced Tasks and Querying Creating Reports and Graphs with SAS Enterprise Guide Available as PublicLive-Web & E-LearningCoursesThis Course includes Conditional ProcessingC op yr i g h t 2 0 1 3 , S A S I n s t i t u t e I n c.
4 A l l r i g h t s r es er v e d .QUESTIONS?C op yr i g h t 2 0 1 3 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d.
