Reinhardt:   I was missing a then...if....then   and i got the following log:    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). 1528 at 74:29 2138 at 74:55 1679 at 74:56 2138 at 76:40  There were 610 observations read from the data set WORK.IMPUTE_MID_SCHOOLS.  There were 459 observations read from the data set WORK.IMPUTE_HIGH_SCHOOLS.  There were 1069 observations read from the data set WORK.TOTALTEACHERS. The data set WORK.TOTALSTUDENTSGRD7TOGRD12 has 2138 observations and 24 variables. ... View more

Reinhardt:   I have included the code and the log. I modified as per your suggestion but it does not give me any obs as seen in the log. SInce i am dividing in the last step I wanted data without any zeros or miss val. all the 3 data sets have the values.       data totalteachers (keep = School County Teachers); set impute_mid_schools impute_high_schools; Total_Teachers=sum(of Teacher_mid Teacher_high); Teachers =ceil(Total_Teachers); run; data totalstudentsgrd7togrd12; set impute_mid_schools impute_high_schools totalteachers; if Teacher_mid>0 and Teacher_high>0; Total_Students_grd7togrd12=sum(of mid_Grd7-mid_Grd12)+sum(of hs_Grd7-hs_Grd12); retain PTRatio_rev 0; PTRatio_rev=Total_Students_grd7togrd12/Teachers; format PTRatio_rev 9.2; run;     log NOTE: There were 610 observations read from the data set WORK.IMPUTE_MID_SCHOOLS. NOTE: There were 459 observations read from the data set WORK.IMPUTE_HIGH_SCHOOLS. NOTE: There were 1069 observations read from the data set WORK.TOTALTEACHERS. NOTE: The data set WORK.TOTALSTUDENTSGRD7TOGRD12 has 0 observations and 24 variables. NOTE: DATA statement used (Total process time):   ... View more

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

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 ... View more

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 ... View more

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. ... View more