4.4. Creating Columns Using Functions in the Expression Editor
SAS Enterprise Guide has many built-in functions you can use to build expressions when creating new columns. A function takes a value and turns it into another related value. For example, the MONTH function will take a date and return just the month. The LOG function will return the natural log of a number. There are many functions to choose from in over 20 different categories including: arithmetic, character, date and time, descriptive statistics, financial, trigonometric, and truncation. Some of the commonly used functions are listed in the next section. Use the Query Builder to create new columns using functions.
Here is a portion of the Bookings Excel file which has been converted ...
Get The Little SAS® Book for Enterprise Guide® 4.1 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
