Page 35 - SAS_manual
P. 35

Character function:
                                                   Purpose:                                 Syntax
                   UPCASE                  Returns the value with base E                 upcase(argument)


                  LOWCASE                  Returns the value with base 10               lowcase(argument)
                  PROPCASE                   Returns the reminder value                 propcase(argument)

               Program 4.5:


                                                        Output:










                                           Purpose:                                     Syntax
                                Extract the set of characters from given
                  SUBSTR                                                   substr(string, position,[no. of characters])
                                               value

                   SCAN          Extract a single word from given value        scan(string, word no.,[delimiter])
                                 Return the no. of characters excluding
                  LENGTH                                                               length(string)
                                           trailing blanks
                                 Return the no. of characters including
                 LENGTHC                                                               lengthc(string)
                                           trailing blanks
               **the sections which are in square bracket is optional


               Program 4.6:











                                                    SAS HANDBOOK | VISIT:: http://nikhilanalytics.com  35
   30   31   32   33   34   35   36   37   38   39   40