BookmarkSubscribeRSS Feed
lucas_palin_sas_com
Calcite | Level 5

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}

 

2 REPLIES 2
ChrisNZ
Tourmaline | Level 20

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

lucas_palin_sas_com
Calcite | Level 5

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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1794 views
  • 0 likes
  • 2 in conversation