Winter Savings - Save on IT Training Using Promo Code FROSTBYTE


SAS(R) Functions by Example

  • Tuition USD $1,800 GSA  $1,496.22
  • Reviews star_rate star_rate star_rate star_rate star_half 2006 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.

Course material was good. Instructor knew his stuff. The only problem I had was with the delivery of the labs. There were occasional times when the vm would take a long time to load, and some of the labs had typing mistakes that cause confusion.

The course content and the delivery by the Instructor was good. I had a good learning experience with ExitCertified. Definitely recommend it to others.

Great training company. Use them. Worth every penny. Instructors are great, equipment is great, system is great.

Great personnel and facility. I just should have been told i was the only person physically in thr class, and that there was an option to attend the class remotely.

Delivered the expected level of training in an easier to understand way than expected.

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