topic Re: Compute across a row and add the result to a running total for that row . has miss num values. in SAS Studio

Compute across a row and add the result to a running total for that row . has miss num values.

savannah — Fri, 13 Jul 2018 02:33:36 GMT

data new;

set work.get1;

do i=1 by 1 until (last.City);
Total(i)=sum(of auto_1/PE-auto_4/PE);
end;

run;

I would like to divide the $amount of each automobile by a factor called PE and then add to a running total for that row. Indefinite number of cities.

CITY Auto_1 Auto_2 Auto_3 Auto_4 PE Total

City 1 Total 1

City 2 Total 2

City 3 Total 3

. .

 sum_range=sum(of a1-a5);
run;

retain total1 =0;

total1=total1+

Re: Compute across a row and add the result to a running total for that row . has miss num values.

pau13rown — Fri, 13 Jul 2018 03:27:11 GMT

data new;

retain sumtotal;

set get1;

auto1=auto_1/PE;

etc:

total=sum(of auto1-auto4);

sumtotal=sumtotal+total;

run;

Re: Compute across a row and add the result to a running total for that row . has miss num values.

savannah — Fri, 13 Jul 2018 03:31:00 GMT

Thank you for your response. How do I do that for all the listed cities for (column name=CITY) and I do not know the number of cities.

Re: Compute across a row and add the result to a running total for that row . has miss num values.

Reeza — Fri, 13 Jul 2018 15:01:21 GMT

It doesn't matter. SAS does that automatically.

If it doesn't work post your code.

@savannah wrote:

Thank you for your response. How do I do that for all the listed cities for (column name=CITY) and I do not know the number of cities.

Re: Compute across a row and add the result to a running total for that row . has miss num values.

savannah — Fri, 13 Jul 2018 18:41:07 GMT

i think you have use the syntax 'divide'

want a running total

data new_mid_total;

set work.ok_mid1;

do i=1 by 1 until (last.City);
Total(i)=sum(of divide(Auto_1/PE)-divide(Auto_2/PE));
end;

run;

i get an error:

ERROR: Undeclared array referenced: Total.

ERROR: Undeclared array referenced: divide.

ERROR: Variable divide has not been declared as an array.

Thanks for your help

Re: Compute across a row and add the result to a running total for that row . has miss num values.

Reeza — Fri, 13 Jul 2018 18:44:09 GMT

Show an example of your data and what you want as output and we can help suggest methods. Showing us problematic code isn't going to keep moving this forward.

If it's resolved, please mark it as solved and post the solution for future users.

@savannah wrote:

i think you have use the syntax 'divide'

want a running total

data new_mid_total;

set work.ok_mid1;

do i=1 by 1 until (last.City);
Total(i)=sum(of divide(Auto_1/PE)-divide(Auto_2/PE));
end;

run;

i get an error:

ERROR: Undeclared array referenced: Total.

ERROR: Undeclared array referenced: divide.

ERROR: Variable divide has not been declared as an array.

Thanks for your help

Re: Compute across a row and add the result to a running total for that row . has miss num values.

savannah — Fri, 13 Jul 2018 19:07:42 GMT

CITY Auto_1 Auto_2 Auto_3 Auto_4 PE Auto1/PE Auto2/PE....>> Total Cummulative Total

City 1 40 60 65 55 0.5 Total 1 Total 1

City 2 . . 44 54 1.2 Total 2 Total 1+Total2

City 3 32 41 45 0.9 Total 3 Total 1 + total2 + total3

data has missing values

Total is of all Auto/PE for that row

Hope that helps

Re: Compute across a row and add the result to a running total for that row . has miss num values.

Reeza — Fri, 13 Jul 2018 19:08:54 GMT

Is that what you want or what you have? Please clearly identify which is already calculated,w hat you want calculated and what the values would be for the data shown so we can verify the calculations on our side.

@savannah wrote:

CITY Auto_1 Auto_2 Auto_3 Auto_4 PE Auto1/PE Auto2/PE....>> Total Cummulative Total

City 1 40 60 65 55 0.5 Total 1 Total 1

City 2 . . 44 54 1.2 Total 2 Total 1+Total2

City 3 32 41 45 0.9 Total 3 Total 1 + total2 + total3

data has missing values

Total is of all Auto/PE for that row

Hope that helps

Re: Compute across a row and add the result to a running total for that row . has miss num values.

savannah — Fri, 13 Jul 2018 19:20:41 GMT

I want to calculate the Auto/PE values and get a total and then a running cummulative total