topic Re: DS2 / RTDM (convert a result table to array) in SAS Programming

DS2 / RTDM (convert a result table to array)

lucas_palin_sas_com — Thu, 03 Nov 2016 18:52:28 GMT

I would like to convert a oracle table to array , using ds2 , for RTDM.

package return_column/overwrite=yes;

/* read table*/

declare package sqlstmt m_stmtSelectArrasto('
select column1, column2 , column3
from table
;

/*write a array*/

column1 column2 column3

a1 a2 a3

b1 b2 b3

c1 c2 c3

Convert to

character_list {a1,b1,c1}

character_list {a2,b2,c2}

character_list {a3,b3,c3}

Re: DS2 / RTDM (convert a result table to array)

ChrisNZ — Mon, 07 Nov 2016 03:07:31 GMT

Sorry, your intentions are unclear (to me at least).

Re: DS2 / RTDM (convert a result table to array)

lucas_palin_sas_com — Wed, 09 Nov 2016 15:12:53 GMT

I need to create a code to use in RTDM because rtdm data processing returns only one record. And I need to return more than one. for it would create a DS2, read a table, using parameters to filter. In return this reading, I would receive from 1 to N records. and this return would have values in a arraylist.