Hi, I often have to transform large sets of variables for use in regression, and how I normally hand the task is to manually code arrays for each of the new transformed variables, similar to the this example: data example;   input A B C;   array var A B C;   array change r_A r_B r_C;   do i = 1 to dim(change);        change = var/lag(var) - 1;   end;   datalines; 10 20 30 15 5 60 25 30 10 run; This becomes very tedious when you have large numbers of variables. I was hoping to get to something like the following, but I have not been able to create functioning code. Not sure if a macro loop is the right way to go, been trying to use a combination of vname and cat functions but no luck so far. data example;   input A B C;   array var _NUMERIC_;   array change /*code that adds the prefix "r_" to all variables in var[]*/;   do i = 1 to dim(change);   change = var/lag(var) - 1;   end;   datalines; 10 20 30 15 5 60 25 30 10 run; Any ideas? ... View more

Hi, I am using the lag function inside of a do loop, however it seems to return the current value of the variable, not the lagged value. I did some testing, if I do the calculation outside of the loop, such as test = lag(var[1]); it works fine. however that same code inside the loop does not return a lagged value, but the current one. I have used very similar statements in other parts of my code which work fine, not sure what is different in this case. desired result for st08, obs 6 = (-1) + (0)*(0.8) +  (0)*(0.8)*(0.8) + (0)*(0.8)*(0.8)*(0.8) = -1 actual result = (-1) + (-1)*(0.8) +  (-1)*(0.8)*(0.8) + (-1)*(0.8)*(0.8)*(0.8) = -2.952 data star;      input star;      datalines;      0      0      0      0      0      -1 run; data star;      set star; array var[1] star; array result st01-st09; do i=1 to 9; result = var[1] + lag(var[1])*(i/10) + lag2(var[1])*(i/10)*(i/10) + lag3(var[1])*(i/10)*(i/10)*(i/10); end; run; Any ideas on what is wrong? ... View more

Hi, I would like customize proc univariate output such that it generates a table that has the class variables as row labels and descriptive statistics as the column labels. Is this possible? I plan to use the table to generate a graph, the default output does not arrange the data in a way to make this easy. I am currently copy/pasting the one or two numbers at a time into excel, I figure there must be a better way. Thank you ... View more

Hi, I have a large data set and I am trying to run correlations every 60 observations, so far I have written this: proc corr data=warnost.currency (firstobs=5614 obs=5673);      var /* my variables */; run; This runs a proc corr on the last 60 days. Below is what I am trying to accomplish, but I don't think you can do a loop with the proc corr inside it (syntax is horrible, I am just trying to convey my idea). Any ideas? first = 5614 last = 5673 Do Until first < 0;           proc corr data=warnost.currency (firstobs=first obs=last);           var /* my variables */;      run;      first = first - 60;      last = last -60; Loop; ... View more