topic Re: Assign first value for the array in SAS Programming

Assign first value for the array

Cruise — Fri, 23 Feb 2018 02:08:05 GMT

How to assign first variable of the array to 0 here? Below code creates rate1-rate11 taking values from 0.1 through 1.1. But I want rate1 starts at 0 so that rate11 would take 1.

data check; set temp;
  array rate rate01-rate11;
  do i=1 to dim(rate);
    rate(i)=i/10;
  end;
  drop i;
run;

Re: Assign first value for the array

art297 — Fri, 23 Feb 2018 02:15:10 GMT

data check; set temp;
  array rate rate01-rate11 (0);
  do i=2 to dim(rate);
    rate(i)=(i-1)/10;
  end;
  drop i;
run;

Art, CEO, AnalystFinder.com

Re: Assign first value for the array

Cruise — Fri, 23 Feb 2018 02:17:01 GMT

ha, worked out. I ignore "WARNING: Partial value initialization of the array rate."

Re: Assign first value for the array

Cruise — Fri, 23 Feb 2018 02:29:00 GMT

@art297

Bummer, I'm doing calculations using resulting array. The solution provided doesn't work with subsequent arithmetic functions. Any alternatives?

data check; set temp;
  array rate rate01-rate21 (0);
  do i=2 to dim(rate);
    rate(i)=1+(i-1)/5;
  end;
  drop i;
run;

Re: Assign first value for the array

art297 — Fri, 23 Feb 2018 02:35:25 GMT

I don't understand what you're saying. Do the variables fate01 thru rate21 already exist in the file temp?

Show an example but, this time, include an example of what file temp looks like.

Art, CEO, AnalystFinder.com

Re: Assign first value for the array

Cruise — Fri, 23 Feb 2018 02:41:15 GMT

@art297

This is temp:

this is what I'm trying to achieve:

data test_s1;
  set temp(where=(county=1));
  denom=tot_pop+sum_inflow-sum_outflow;
  array rate rate01-rate21 (0);
  do i=2 to dim(rate);
    rate(i)=((tot_case+(agerisk*((i-1)/5)*sum_inflow)-agerisk*sum_outflow)/denom)*us_age_dist;
  end;
  drop i;
run;

the problem is that rate01 turns out to be 0 in test_s1. however, rate01 is not supposed to be zero, right?

Re: Assign first value for the array

art297 — Fri, 23 Feb 2018 03:32:50 GMT

You said, in your first post, that you want rate01 to have a value of 0. What am I missing?

Do you really only want rate01 to rate20 with each variable taking on the stated computation?

Art, CEO, AnalystFinder.com

Re: Assign first value for the array

Cruise — Fri, 23 Feb 2018 03:44:31 GMT

I replaced 'do i=2' to 'do i=1' which solved the problem. Because I wanted rate01 take zero and get it's value reflected in the subsequent computation.