SAS(R) Functions by Example

  • Tuition USD $1,650 GSA  $1,496.22
  • Reviews star_rate star_rate star_rate star_rate star_half 1076 Ratings
  • Course Code BFEX94
  • Duration 2 days
  • Available Formats Classroom

Ever spent valuable time writing complex code only to later find a function that would have done the job for you? Discover the plethora of practical SAS functions that you haven't seen in other SAS programming courses, and start resolving your everyday programming problems more quickly and efficiently.

Skills Gained

  • magically manipulate character data with ease, using PERL Regular Expression (PRX) and other amazing character functions
  • dominate datetime, date, and time values with the previously perplexing Date Interval functions
  • save programming time and reduce programmer frustration with array functions
  • easily compute descriptive statistics, including how to use the new SMALLEST and LARGEST functions
  • use mathematical and special functions to streamline your code
  • generate random numbers with ease
  • manipulate the values in various variables with CALL SORTN and CALL SORTC routines.

Who Can Benefit

  • Base SAS programmers who want to write more elegant, efficient DATA step and PROC SQL programs


  • Before attending this course, participants should have completed the SAS® Programming 1: Essentials course. Completion of the SAS® Programming 2: Data Manipulation Techniques course is also recommended or, alternatively, a minimum of one year of SAS programming experience.

Course Details

Character Functions Part 1

  • storage length of character variables
  • functions that change case
  • functions that extract and search for strings
  • functions that join strings
  • functions that remove blanks from strings or take strings apart
  • functions that count substrings or characaters

Character Functions Part 2

  • the ANY and NOT functions
  • functions that replace words or characters
  • functions that compare strings

Date and Time Functions

  • SAS date functions
  • SAS time functions
  • SAS datetime functions
  • SAS interval functions

Array functions

  • the DIM function
  • array boundaries and the related functions
  • temporary arrays

Descriptive Statistics Functions

  • functions that count missing and nonmissing values for SAS variables
  • functions that compute descriptive statistics
  • functions that determine the ordering of data values

Special Truncation and Mathematical Functions

  • special functions
  • functions to obtain values from previous functions
  • truncation functions
  • commonly used mathematical functions

Random Number Functions

  • uniform random numbers
  • randomly generated data sets
  • selecting random subsets of a SAS data set
  • random assignments of subjects
  • random number call routine

Variable Information Functions

  • selected V functions

Perl Regular Expresssion Functions

  • writing regular expressions
  • the PRX functions

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

Should allow student to download the software of the e-Textbook though out agency can't give the permition to download file out of the firewall.

The course material and instructor were very good. easy to follow, lab was setup nicely and was able to complete most of the lab material.
The Koretex App is absolute garbage and very cumbersome to use on a tablet/ipad. A PDF file would be 100 times better than that atrocious app.
As a recommendation this class should be 5 days instead of 4 as some chapters had to be rushed.

This was my first course through ExitCertified. From my initial browsing of their website for courses, assistance getting the course procured for my agency, and finally the course experience itself, I couldn't be more pleased.

Very clean, great cafeteria and well sorted, very kind staff. The bathrooms have to be expanded as they might get crowded sometimes

Virtual delivery and coordination of the course was great. It had to be rescheduled several times by ExitCertified was always on top of things.

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward