NOTUPPER AND NOTLOWER

 Function: NOTLOWER

Purpose: To  determine the position of the first character in a string that is not a lowercase letter. If none is found, the function returns a 0. 
With the use of an optional parameter, this function can begin searching at any position in the string and can also search from right to left, if desired.
                                 
Syntax: NOTLOWER(character-value <,start>)     

character-value  Is any SAS character value.

Start is an optional parameter that specifies the position in  the string to begin search. If it is omitted,the search starts at the beginning of the string. If it is non-zero, the search begins at the position in the string of the absolute value of the number (starting from the left position in the string). If the start value is positive, the search goes from left to right; if the string is negative, the search goes from right to left, starting at the end of the string. If the value of start is a positive number longer that the length of the sting, or it is 0 , the function returns a 0.

Example:
For these examples, STRING = "abc 123 ?XYZ_n_" 
Output
Functions                                                 Returns
NOTLOWER("ABCDabcd")                       1 (position of "A")
NOTLOWER("abcdefg")                            0 (all lowercase characters)
NOTLOWER(STRING)                                4 (position of blank)
NOTLOWER("??$$%%")                           1 (position of "?")
NOTLOWER(STRING,5)                             5 (position of "1")
NOTLOWER(STRING,-6)                           6 (position of "2")
NOTLOWER(STRING,6)                             6 (position of "2")


 
 Function: NOTUPPER

Purpose: To  determine the position of the first character in a string that is not an uppercase letter. If none is found, the function returns a 0. 
With the use of an optional parameter, this function can begin searching at any position in the string and can also search from right to left, if desired.

Syntax: NOTUPPER(character-value <,start>)     

character-value  Is any SAS character value.

Start is an optional parameter that specifies the position in  the string to begin search. If it is omitted,the search starts at the beginning of the string. If it is non-zero, the search begins at the position in the string of the absolute value of the number (starting from the left position in the string). If the start value is positive, the search goes from left to right; if the string is negative, the search goes from right to left, starting at the end of the string. If the value of start is a positive number longer that the length of the sting, or it is 0 , the function returns a 0.

Example:
For these examples, STRING = "ABC 123 ?XYZ_n_" 
Output
Functions                                                 Returns
NOTUPPER("ABCDabcd")                       5 (position of "A")
NOTUPPER("abcdefg")                            0 (all lowercase characters)
NOTUPPER(STRING)                                4 (position of first blank)
NOTUPPER("??$$%%")                           1 (position of "?")
NOTUPPER(STRING,5)                             5 (position of "1")
NOTUPPER(STRING,-6)                           6 (position of "2")
NOTUPPER(STRING,6)                             6 (position of "2")


NOTE: 
As with most character fuctions, be careful with the trailing blanks, this is the reason we obtain  4th postion.


















Location: Nairobi, Kenya

Comments

Post a Comment

Popular posts from this blog

Function :MDY

Image
 For the situations where you  only have month, day , and year values but do not have a SAS Date, the MDY functon can create a SAS date value, given the value for the month, day , and year .Kindly find a detailed example on how this is made possible in SAS Purpose:   To create a SAS Date from the month, day and year. Sytax: MDY(month, day, year)               month is a numeric variable or constant representing the month of the year (a number               from 1 to 12 ).               day   is a numeric variable or constant representing  the day of the month (a number                  from 1 to 31 ).               year  is a numeric variable or constant representing the year. Values of the month, day and time that do not define a valid date result in a missing value and...
Read more

UPCASE, LOWCASE & PROPCASE

Image
!) Function:   UPCASE Purpose:   To  change all letters to uppercase.                                                  NOTE: The corresponding fuction LOWCASE changes uppercase to lowcase Syntax : UPCASE(character-value)                                 character-value is any SAS character value.             If a length has not been previously assigned, the length of the resulting             variable will be the length of the argument Example: ***Primary function: UPCASE ***Other function: DIM; data mixed;   length a b c d e $ 1 ;   input a b c d e x y;   datalines ;   M f P p D 1 2   m f m F M 3 4 ; run ;   data upper;   set mixed;   arra...
Read more

COMPBL(Compress blanks)

Image
  !) Function:   COMPBL Purpose:   To replace all occurrences of two or more blanks with a single blank character.  This is particularly useful for standardizing  addresses and names where  multiple blanks may have been entered. Syntax : COMPBL(character-value)                                 character-value is any SAS character value.             If a length has not been previously assigned, the length of the resulting             variable will be the length of the argument Example: Using the Combl function to convert multiple blanks to single blank. ***Primary function: COMPBL; data squeeze; input # 1 @ 1 Name $20. # 2 @ 1 Address $30. # 3 @ 1 City $15.    @ 20 State $2.    @ 25 Zip $5. ;   Name = compbl(Name);   Address = compbl(Address);   City...
Read more