• Contents
  • About
  • What’s New in DataFlux Expression Language 2.7: Reference Guide
  • Expression Engine Language
    • Introduction
      • Overview of the Expression Engine Language
    • Data Job Expressions Node
      • Data Job Expressions Node
  • Expression Engine Language Functions
    • Array Functions
      • Array Functions
      • DIM Function
      • GET Function
      • SET Function
    • Data Quality Functions
      • Data Quality Functions
      • DQ.CASE Function
      • DQ.EXTRACT Function
      • DQ.GENDER Function
      • DQ.GETLASTERROR Function
      • DQ.IDENTIFY Function
      • DQ_INITIALIZE Function
      • DQ.LOADQKB Function
      • DQ.MATCHCODE Function
      • DQ.MATCHSCORE Function
      • DQ.PARSE Function
      • DQ.PATTERN Function
      • DQ.STANDARDIZE Function
      • DQ.TOKEN Function
      • DQ.TOKENVALUE Function
      • DQ.VALUE Function
    • Database Functions
      • Overview
      • Overview of the Database Objects
      • Releasing Database Objects
      • DBCONNECT Function
      • DBDATASOURCES Function
    • Date and Time Functions
      • Overview
      • FORMATDATE Function
      • TODAY Function
      • TODAYGMT Function
    • Execution Functions
      • Overview
      • PUSHROW Function
      • SETOUTPUTSLOT Function
      • SLEEP Function
    • File Functions
      • Overview
      • CLOSE Function
      • COPYFILE Function
      • DELETEFILE Function
      • EXECUTE Function
      • FILEDATE Function
      • FILEEXISTS Function
      • MKDIR Function
      • MOVEFILE Function
      • OPEN Function
      • POSITION Function
      • READBYTES Function
      • READLINE Function
      • RMDIR Function
      • SEEKBEGIN Function
      • SEEKCURRENT Function
      • SEEKEND Function
      • WRITEBYTES Function
      • WRITELINE Function
    • Incoming Data Functions
      • Overview
      • FIELDCOUNT Function
      • FIELDNAME Function
      • FIELDTYPE Function
      • FIELDVALUE Function
      • READROW Function
      • ROWESTIMATE Function
      • SETEOF Function
      • SETFIELDVALUE Function
    • Information/Conversion Functions
      • Overview
      • DETERMINE_TYPE Function
      • GEODISTANCE_COSINE Function
      • GEODISTANCE_HAVERSINE Function
      • ISALPHA Function
      • ISBLANK Function
      • ISNULL Function
      • ISNUMBER Function
      • IS_PREVIEW_MODE Function
      • LOCALE Function
      • TOBOOLEAN
      • TYPEOF Function
    • Logging Functions
      • Overview
      • LOGMESSAGE Function
      • PRINT Function
      • RAISEERROR Function
      • SENDNODESTATUS Function
    • Macro and Variable Functions
      • Overview
      • GETVAR Function
      • SETVAR Function
      • VAREVAL Function
      • VARSET Function
    • Mathematical Functions
      • Overview
      • ABS Function
      • CEIL Function
      • FLOOR Function
      • MAX Function
      • MIN Function
      • POW Function
      • ROUND Function
    • Node Functions
      • Overview
      • PCTCOMPLETE Function
      • RAISEEVENT Function
      • SENDNODESTATUS Function
      • SETOUTPUTSLOT Function
      • UNIQUEID Function
    • Regular Expression Functions
      • Overview
      • COMPILE Function
      • FINDFIRST Function
      • FINDNEXT Function
      • MATCHLENGTH Function
      • MATCHSTART Function
      • REPLACE Function
      • SUBSTRINGCOUNT Function
      • SUBSTRINGLENGTH
      • SUBSTRINGSTART Function
    • Search Functions
      • Overview
      • INLIST Function
    • String Functions
      • Overview
      • APARSE Function
      • ASC Function
      • CHR Function
      • COMPARE Function
      • EDIT_DISTANCE Function
      • HAS_CONTROL_CHARS Function
      • INSTR Function
      • LEFT Function
      • LEN Function
      • LOWER Function
      • MATCH_STRING Function
      • MID Function
      • PARSE Function
      • PATTERN Function
      • REPLACE Function
      • RIGHT Function
      • SORT Function
      • SORT_WORDS Function
      • TODATE Function
      • TOINTEGER Function
      • TOREAL Function
      • TOSTRING Function
      • TRIM Function
      • UPPER Function
      • USERNAME Function
  • Appendixes
    • Frequently Asked Questions
    • Reserved Words
    • ASCII Values
      • ASCII Values
      • ASCII Control Characters
    • Encoding
    • Legal Notices


ProductRelease
SAS Data Loader for Hadoop
SAS Data Management Advanced
SAS Data Management Standard
DataFlux Data Management Studio2.7
DataFlux Data Management Server2.7
Type
Usage and Reference
Copyright Date
January 2016
Last Updated
19Jan2016