Sticky-note

The VALUE statement creates the $SKILL. format, which prints each employee's identification number and the skills test they have been assigned. Employees must take either TEST A, TEST B, or TEST C, depending on their last name. The exclusion operator (<) excludes the last value in the range. Thus, the first range includes employees whose last name begins with any letter between A and D, and the second range includes employees whose last name begins with any letter between E and M. The tilde (~) in the last range is necessary to include an entire string that begins with the letter Z.

   value $skill  'a'-<'e','A'-<'E'='Test A'
                 'e'-<'m','E'-<'M'='Test B'
                 'm'-'z~','M'-'Z~'='Test C';
run;