topic Problem with arrays format in New SAS User

Problem with arrays format

KBou — Fri, 14 Feb 2020 14:09:58 GMT

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 !

Re: Problem with arrays format

ed_sas_member — Fri, 14 Feb 2020 14:15:32 GMT

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?

Re: Problem with arrays format

KBou — Fri, 14 Feb 2020 14:16:50 GMT

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

Ty sir