Problem with arrays format

[KBou]

Hi, 

I recently got an issue and trying to figure out the best way for a work around.

Here's sample of my code

Data cash_flow;
set cash_flow
(rename= (FLOW_T_1-FLOW_T_&nb_s=FLOW_POS_1-FLOW_POS_&nb_s ));

array FLOW_POS_ {&nb_s} $ FLOW_POS_1-FLOW_POS_&nb_s;
array FLOW_PERFO_ {&nb_s} $ FLOW_PERFO_1-FLOW_PERFO_&nb_s;
do i = 1 to &nb_s;
FLOW_PERFO_[i] = FLOW_POS_[i];
end;

run;

FLOW_POS_[i] will return these vales in numeric format

-123456789 -123456789 -123456789 -123456789 -123456789

FLOW_PERFO_[i] will return these values in character format

-1234E8 -1234E8 -1234E8 -1234E8 -1234E8

I need both in numeric. Any insight would be appreciated, thanks !

[ed_sas_member · Accepted solution]

Hi @KBou 

In your array statements, both arrays are defined as character ($).

What is the type of input variables: FLOW_T_xxx and FLOW_PERFO_xxx ?

Could you please run a proc contents for example?

[KBou]

Oh wow, i feel dumb. Didn't even saw that.

Ty sir