Tips On SaS Functions Well Explained

 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...

Function That Sorts Character Values       Purpose : To sort the values of its character arguments in ascending order   Syntax : CALL SORTC(<of> Char-1 <, … Char-n>)                        Char-n is a character variable. If you use a variable list in the form                       Var1–Varn, precede the list with the word "of"'.                      Arguments to the CALL SORTC routine cannot be constants. You may use                      array references as arguments to this routine as well (see the following examples):         Examples   ...