SAS Event Stream Processing Tip: Use a functional window to parse a string field with a timestamp

[BeverlyBrown]

Hat tip to @AndyT_SAS for providing this shortcut on using a functional window to convert a string field into a date or timestamp field. "Helpful if you don't want to balance all of the parentheses when writing the function from scratch," he said.

In many SAS Event Stream Processing models, he says, the connector or adapter can convert a date or timestamp while reading data from the source. But if the model reads in an opaque string of XML or JSON or a base64 encoded string, the date or timestamp might be in a string field, like 2018-05-28T09:33:55.670Z. 

He provides an example of the functional window in action, plus a complete model and attaches input data. 

Read It!