topic Re: calculate across hourly data in SAS Programming

calculate across hourly data

tobyfarms — Mon, 02 Oct 2017 16:08:53 GMT

I am attempting to calculate "11065865311" across a table of hourly data (hours 1 thru 24). The array that I tried to setup below does not work, actually errors out. Is this the correct path?

data work.delete_Main(drop=i);

set work.delete_merging;

array hours {24} 4 H1-H24;

do i=(hour1) to 1 by -1;

hours[i]=100;

end;

do i=(hour1);

hours[i]=hours/11065865311;

end;

output;

run;

Re: calculate across hourly data

mkeintz — Mon, 02 Oct 2017 16:29:53 GMT

The numerator in the expression

hours/11065865311

should be generating a "error: illegal reference to the array hours" message.

You need to specify an index (i.e. hours{i}, hours{3}, etc.) in the numerator.

Re: calculate across hourly data

Kurt_Bremser — Mon, 02 Oct 2017 16:45:52 GMT

If you get an error, posting the log is essential.

Re: calculate across hourly data

tobyfarms — Mon, 02 Oct 2017 16:47:44 GMT

Agreed, thank you. the log is what @mkeintz mentioned.

ERROR: Illegal reference to the array hours.

The SAS System 08:48 Monday, October 2, 2017

1 %_eg_hidenotesandsource;

5 %_eg_hidenotesandsource;

49 data work.delete_Main(drop=i);

50 /*retain State City Date Dawn Dusk Hour1 Minute1 Hour2 Minute2 ;*/

51 set work.delete_merging;

53 array hours {24} 4 H1-H24;

55 do i=(hour1) to 1 by -1;

56 hours[i]=100;

57 end;

60 do i=(hour1);

61 hours[i]=hours/11065865311;

ERROR: Illegal reference to the array hours.

62 end;

64 output;

65 run;

NOTE: Missing values were generated as a result of performing an operation on missing values.

Each place is given by: (Number of times) at (Line):(Column).

61:27

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.DELETE_MAIN may be incomplete. When this step was stopped there were 0 observations and 33 variables.

WARNING: Data set WORK.DELETE_MAIN was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

real time 0.01 seconds

cpu time 0.02 seconds

Re: calculate across hourly data

Kurt_Bremser — Mon, 02 Oct 2017 17:22:50 GMT

Yes, you can't use the whole array in an assignment, you have to use individual members.

Re: calculate across hourly data

tobyfarms — Mon, 02 Oct 2017 18:00:53 GMT

So am I changing the array script to:

array hours {3} H1 - H24;

do i=1 to 3;

hours{i}=hours/11065865311;

I am not understanding how I the array should be modified.

Re: calculate across hourly data

Kurt_Bremser — Tue, 03 Oct 2017 05:08:11 GMT

hours without an index (as you used it on the right side of the assignment) is invalid.

Re: calculate across hourly data

mkeintz — Mon, 02 Oct 2017 20:41:33 GMT

I repeat, your problem is in the NUMERATOR of hours/11065865311. You need something like hours{I}/11065865311

Re: calculate across hourly data

tobyfarms — Tue, 03 Oct 2017 12:05:33 GMT

Thank you @mkeintz and @Kurt_Bremser.

After your initial reply, I did change the numerator to show the index.