Hi,   suppose that I have a table with 10 ids. Is it possible to create a new variable called "group" such that there are only say 3 groups and they are repetitive in the form 3,1,2,3,1,2,3,1,2 etc:   id group 1 3 2 1 3 2 4 3 5 1 6 2 7 3 8 1 9 2 10 3   Thank you!   ... View more

Hi,   I am trying to replicate a math problem (for more info see the 4 min video https://www.youtube.com/watch?v=m4CjXk_b8zo)   I am doing a loop for numbers 1 to 10. For each number, if it is even then it becomes number/2, and if it is odd then it becomes 3*number+1. I stop the loop for each number when the number becomes 4, and then I go to the next number. For each number I want to count how many steps until the number becomes 4.         Here is my code:   data problem; do i = 1 to 10; count = 0; number = i; do while (number ne 4); if mod(number,2) = 0 then number = number/2; else number = 3*number +1; count = count +1; output; end; end; run; I get the result that I want, but the output gives me all the steps for each i. Is it possible to get only the last step for each i?     Thanks! ... View more

Hi,   I have a table of historical stock prices, among other things, where each stock is in a column. I also have all the names of the stocks in a macro list called "symbol". I would like to calculate the return for each stock. I have tried the following code:   %macro returns(all_data); %let k=1; %let symbol= %scan(&all_data, &k); %do %while("&symbol" NE ""); &symbol&_&ret = log(&symbol) - log(lag(&symbol)); %let k = %eval(&k + 1); %let symbol = %scan(&all_data, &k); %end; %mend; data returns; set returns; %returns(&symbol); run; But the code doesn't work. I don't get any error message, but the new stock return columns don't appear.   Thanks!     ... View more

Hi,   suppose that I have the following table:   date  stock price 21-Jan-10 A 1 22-Jan-10 A 3 21-Jan-10 B 10 22-Jan-10 B 15   when I do the following code:   proc sort data=have; by date; run; proc transpose data=have out=want ; by date; run; I ge the result: date _NAME_ _LABEL_ COL1 COL2 21/01/2010 price price 1 10 22/01/2010 price price 3 15   But the names of the stocks (A and B) appear as COL1 and COL2 - is it possible to have the real names of the stocks?   Thank you! ... View more