1) create table with one number I used this code: proc sql; create table max_table as select max(numeric_column) as max_column from anydataset; quit; in this created table max_table I have 1 column (max_column) with a certain number (likely between 1-20, it may vary each time run the code) 2) create macro variable with this value data _NULL_; set max_table ; call symput('max_arr', max_column); run; 3) set array with this value and I want to retain the values. This is my current version that works. data test2; set test; array date_s{&max_arr}; retain date_s1-date_s16; /*other code that does calculations for the array*/ run; note that I put the 1-16 manually, because at the moment the array has 16 values (the max from the inital table was 16) 4) what I want is to make this dynamic, like the following (this does not work) data test2; set test; array date_s{&max_arr}; retain date_s1-date_s&max_arr; /*other code that does calculations for the array*/ run; I hope my explanation of the problem is clear. How can I make this dynamic?
... View more