DATA Step, Macro, Functions and more

DS2 / RTDM (convert a result table to array)

Reply
New Contributor
Posts: 2

DS2 / RTDM (convert a result table to array)

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}

 

PROC Star
Posts: 1,760

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

Posted in reply to lucas_palin_sas_com

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

New Contributor
Posts: 2

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

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.

Ask a Question
Discussion stats
  • 2 replies
  • 253 views
  • 0 likes
  • 2 in conversation