Yes, you can build IF-THEN syntax and logic in SAS Enterprise Guide. The Query Builder can be used to generate CASE syntax in PROC SQL which is very similar to IF-THEN logic that is available in the DATA step. Complete the following steps:

1. Select File Open From SAS Server/Binder, and choose the Server if it is not already selected.
2. Choose Libraries, and then select the SASHELP library.
3. Select and open the CLASS data set.
4. Close the data grid.
5. With the data selected, select Data Filter and Query Active Data.
6. Click the Select and Sort tab.
7. Click New.
8. Click Change beside the Format area.
9. Under Categories, choose Character.
10. Under Formats, choose $w.
11. Under Attributes, assign an Overall width of 10.
12. Click OK.
13. Assign a new name. For this example, enter Teen in the Alias field.
14. Click Change beside Expression.
15. In the Expression Builder, under Name, double-click CASE {else} which populates the Expression area.
16. Format the expression to match the following:
    
    

    CASE WHEN <whenCondition> THEN <resultExpression> WHEN <whenCondition> THEN <resultExpression> ELSE <resultExpression> END

    
    
    
17. Select and remove the first <whenCondition>.
18. From the Values tab, double-click Age to populate the first When condition.
19. After the When condition, enter: <=12
20. Select and remove the first <resultExpression>.
21. Replace it with: “Pre-Teen”
22. Select and remove the second <whenCondition>.
23. From the Values tab, double-click Age to populate the second When condition.
24. After the When condition, enter: >=13
25. Select and remove the second <resultExpression>.
26. Replace it with: “Teen”
27. Select and remove <resultExpression> beside the ELSE.
28. Replace it with: “Other”
29. The final syntax in the Expression Builder for this example should be:
    
    

    CASE WHEN CLASS.Age <=12 THEN "Pre-Teen" WHEN CLASS.Age >=13 THEN "Teen" ELSE "other" END

    
    
    
30. Click OK twice.
31. Click Run Query to generate the results.

You will see a new character column, Teen, with values of “Pre-Teen” or “Teen” which are based on the values of the Age Column.

Note: These steps are based on SAS Enterprise Guide 3.0.2.446.

Operating System and Release Information