OverviewIntroductionObjectivesUnderstanding SAS FunctionsUses of SAS FunctionsExample of a SAS FunctionGeneral Form of SAS FunctionsArguments, Variable Lists, ArraysExampleTarget VariablesConverting Data with FunctionsIntroduction to Converting DataPotential Problems of Omitting INPUT or PUTAutomatic Character-to-Numeric ConversionWhen Automatic Conversion OccursRestriction for WHERE ExpressionsExplicit Character-to-Numeric ConversionExampleAutomatic Numeric-to-Character ConversionExplicit Numeric-to-Character ConversionMatching the Data TypeManipulating SAS Date Values with FunctionsSAS Date and Time ValuesSAS Date FunctionsYEAR, QTR, MONTH, and DAY FunctionsExample: Finding the Year and MonthExample: Finding the Year and Month (continued)Example: Finding the YearWEEKDAY FunctionMDY FunctionExample: Finding the DateDATE and TODAY FunctionsINTCK FunctionExamplesExample: The INTCK FunctionINTNX FunctionDATDIF and YRDIF FunctionsModifying Character Values with FunctionsIntroduction to Modifying Character ValuesCharacter FunctionsSCAN FunctionSpecifying DelimitersSpecifying Multiple DelimitersDefault DelimitersSCAN Function SyntaxSpecifying Variable LengthSCAN versus SUBSTRSUBSTR FunctionReplacing Text Using SUBSTRPositioning the SUBSTR FunctionTRIM FunctionPoints to RememberCATX FunctionINDEX FunctionFinding a String Regardless of CaseFIND FunctionExampleUPCASE FunctionLOWCASE FunctionPROPCASE FunctionTRANWRD FunctionModifying Numeric Values with FunctionsIntroduction to Modifying Numeric ValuesINT FunctionROUND FunctionNesting SAS FunctionsChapter SummaryText SummaryUsing SAS FunctionsAutomatic Character-to-Numeric ConversionExplicit Character-to-Numeric ConversionAutomatic Numeric-to-Character ConversionExplicit Numeric-to-Character ConversionSAS Date and Time ValuesYEAR, QTR, MONTH, and DAY FunctionsWEEKDAY FunctionMDY FunctionDATE and TODAY FunctionsINTCK FunctionINTNX FunctionDATDIF and YRDIF FunctionsSCAN FunctionSUBSTR FunctionSCAN versus SUBSTRTRIM FunctionCATX FunctionINDEX FunctionFIND FunctionUPCASE FunctionLOWCASE FunctionPROPCASE FunctionTRANWRD FunctionINT FunctionROUND FunctionNesting SAS FunctionsSyntaxSample ProgramsPoints to RememberChapter Quiz