topic How to create a hive array from sas data set? in SAS Programming

How to create a hive array from sas data set?

ARC2 — Fri, 12 Jun 2020 04:38:33 GMT

Say I have a SAS dataset (or a hive table) with an id variable plus variables x1-x5 and I want to read this data into a hive table with the x1-x5 in a hive array. What goes in the select statement to get those variables into an array? Or is select not the right way?

Thanks.

Re: How to create a hive array from sas data set?

Patrick — Fri, 12 Jun 2020 06:24:52 GMT

That's not a SAS but a Hive SQL question.

After a quick Google seems there is an array() function for this.

From: https://dwgeek.com/hive-array-functions-usage-and-examples.html/

Following is the syntax of array function.

array(value1, value2, value2,...)

where, value is of type string or integer.