Thanks Ksharp and Reeza, This has been very helpful - especially using the var_list macro. However, I am trying to do something slightly different than the solution you proposed, and I think it is because I did not explain my issue well enough. I am attempting to sum down the columns for each var that ends in _population, and not across all rows that end in _population for each observation. For example, I want to sum down ob_population to get (50+100+55)=205, and create a new var such as ob_population_sum, and continue to do this for x_population, c_population, and so on. Essentially, I am trying to create a new row that corresponds to the total of a column summed above it. I've tried using something as: proc sql;
create table region1_3 as select *,
sum(&var_list) as x_total
from region1;
quit; but I'm still getting a new column that corresponds to summing across rows, not a new row that corresponds to summing down the _population columns. How do I sum down these columns, using the var_list macro? Thanks.
... View more