Hi. I'm trying to import xlsx.files but all of the variables doesn't being imported. My variables are about 1,500 . I have several excel files that have to import so  want to use macro.  How can I import this file using macro?   I used the following code: proc import out = work.data1 datafile = 'C:\sw\desktop\data1.xlsx' dbms=xlsx replace; sheet=sheet1; getnames=yes; run;   my data: date            APPLE     AT&T   CB ... MS ... 01.01 2000    1.2         1.3     1.2 ... 4.2 ... 02.01 2000    1.3         1.5     1.7 ... 3.2 ...   Your help is truly appreciated. Thanks.   ... View more

dear sas members   hi   i'm trying to calculate cumulative returns, but i dont know how can i do...    i want to calculate monthly return by using daily returns. [(1+R1)(1+R2)...(1+Rn)]-1   my data set: date return(%) 19910801 5 19910802 3 19910803 2 19910804 3 ... 19910831 3 19910901 -1 19910902 -0.8 ...   (from 1991081 to 20151231)   Is there any way to calculate cumulative return for each month?     Your help is truly appreciated!   Thanks,   ... View more