I have one more question: need to loop through columns (variables) and calculate the difference between next and prior value. The table is as follows: Y_1950 Y_1960 Y_1970 Y_1980 Y_1990 Y_2000
3281 3413 3114 2500 2700 3500
4042 3084 3108 3150 3800 3100
6015 6123 6113 6100 6100 6200 I created 2 arrays and wrote such a code: data loopTables; set sashelp.us_data; ARRAY table1 Y_1950-Y_2000; ARRAY diff diff1-diff5; diff[1]=0; do index = 2 to DIM(table1); diff[index] = table1[index]-table1[index-1]; end; run; Unfortunately it doesn't work. I have 2 questions: 1. How can I associate columns names in array if their suffixes increase by 10? (1950, 1960 etc.)? I noticed that 1st array itself returns Y_1950,Y_1951,Y_1952,Y_1953,Y_1954, etc. I need it to return variables as in my origin table. 2. Second array: if my first array returns Y_1950-Y_2000 how I should associate 'diff' with first array to return values from corresponding columns from first array? Sth like diff_1950-diff_2000 or diff_1-diff_5? Would be grateful for any explanation.
... View more