COMPRESS

Function: COMPRESS

Purpose: To remove specified characters from a character value. When used with k modifier , compress can be used to keep characters (such as digits) in a character value and remove everything else.

Syntax:  COMPRESS(character-value <,'compress-list'> <,'modifiers'>)

            character-value is any SAS character value.

compress-list  is an optional list of the characters you want to remove. If this argument is omitted, the default character to be removed is a blank. If you include a list of characters to remove, only those characters will be removed (unless the 'k' modifier is used). If a blank is not included in the list, blanks will not be removed

  modifiers is an optional list of modifiers that refer to character classes For example, the a modifier refers to all uppercase and lowercase characters. The following are some of the more useful modifiers: 




a     include all uppercase and lowercase letters.

d     include all digits

s  include all space characters (blanks, horizontal and vertical tabs, carriage return, linefeed, and formfeed).          

i    ignore the case of characters.

k   keep the characters listed in the compress-list or referenced by the modifiers instead of removing them.include all punctuation characters.referenced by the modifiers instead of removing them.

p  include all punctuation characters.         

Note that the modifiers can be in uppercase or lowercase.

If a length has not been previously assigned, the length of the resulting variable will be the length of the first argument.  



Example: Using the Compress function                                      
In the following examples, CHAR = "A C123XYZ".

Function                                                                    Returns
COMPRESS("A C XYZ")
COMPRESS("(908) 777-1234"," (-)")
COMPRESS(CHAR,,'as')
COMPRESS(CHAR,"0123456789")
COMPRESS(CHAR,,'d')
COMPRESS(CHAR,"ABC",'d')
COMPRESS(CHAR,,'kd') 		"ACXYZ"
"9087771234"
"123"
"A CXYZ"
"A CXYZ"
" XYZ"
"123"
                                                                        








Location: Nairobi, Kenya

Comments

Post a Comment

Popular posts from this blog

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;   array all_c[*] _character_;   do i = 1 to dim(all_c);     all_c[i] = upcase(all_c[i]);   end ;   drop i; run ; title 'Listing of Data Set UPPER' ; proc print data =upper noobs ; run ; Output Explanation Remember that uppercase and lowercase values are represented by different internal codes, so if
Read more

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 an error message is written  to the SAS log.            Examples For these examples, M = 11 , D = 15 , Y = 2003.   Function                                              Returns          MDY(M,D,Y)                
Read more