7 Building CLEM Expressions 105
AboutCLEM................................................................105
CLEMExamples............................................................. 108
ValuesandDataTypes........................................................110
ExpressionsandConditions....................................................111
Stream,Sessi on,and SuperNode Parameters. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 112
WorkingwithStrings.........................................................112
HandlingBla nksand Missing Values. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113
WorkingwithNumbers........................................................114
WorkingwithTimesandDates.................................................. 114
SummarizingMultipleFields....................................................115
Workingwith Multiple-Response Data . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . 117
TheExpressionBuilder...................... .................................. 117
Accessingth eExpression Builder . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . 119
CreatingExpressions......................................................119
SelectingFunctions.......................................................120
SelectingFi elds,Parameters, and Global Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121
ViewingorSelectingValues................................................. 122
CheckingCLEMExpressions................................................ 123
FindandReplace............................................................ 123
8 CLEM Language Reference 127CLEMReferenceOverview.....................................................127
CLEMDatatypes.............................................................127
Integers................................................................128
Reals..................................................................128
Characters ................................................... .......... 128
Strings........................................... ...................... 129
Lists....................................... ............................ 129
Fields..................................................................129
Dates..................................................................129
Time ................................ .................................. 130
CLEMOperators.............................................................131
FunctionsReference..........................................................133
Conventionsi nFunction Descriptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 133
InformationFunctions................................................. .... 134
ConversionFunctions..................................................... 135
ComparisonFunctions..................................................... 135
vi