PROC SQL supports the same SAS functions as the DATA step, except for the functions LAG, DIF, and SOUND. For example, the SCAN function is used in the following query: select style, scan (street,1) ...

Snowflake wants to reduce enterprises’ reliance on data engineers and data scientists for unstructured data analysis with its new SQL functions powered by generative AI.