Discuss all things SAS and IoT.

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

Reply
Highlighted
Community Manager
Posts: 681

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

shortcut.pngHat 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!

 

Ask a Question
Discussion stats
  • 0 replies
  • 135 views
  • 0 likes
  • 1 in conversation