Hi, it says that more positional parameters found than defined and that the execute doesn't have enough arguments. Also, I redid  the call execute in string form : data _null_;    set data_torun;    call execute('%import_myfile(filenum)'); run; but stll the same problem ... View more

Hi Xia, I searched on the internet (including the sas site) and this is what I could put together: %macro import_myfile(i=); proc import file="C:\Documents and Settings\HP_Administrator\Desktop\file\file&i" out=file&i. DBMS= EXCEL REPLACE;    sheet = "Sheet1";      GETNAMES=YES;      MIXED=NO;      SCANTEXT=YES;      USEDATE=YES;      SCANTIME=YES; run; %mend import_myfile; data data_torun; input filenum; datalines; 1 2 3 ;;;; run; data _null_;    set data_torun;    call execute(%import_myfile(filenum)); run; But unfortunately I got an error message... Could you please help me to figure out what is wrong with the above code? Thank you ... View more

I actually tried it and it worked, thanks again! ... View more

I think I realized, by omitting the var statement the code includes all of the variables ... View more

Hi stat@sas, thanks for the reply! Just have a small issue and it is that in my real data I have hundreds of stocks so it will be very helpful if there was another method of putting them all in the code instead of typing each one. Thanks ! ... View more

Hi Tom, thanks for the reply! But in my real case I have hundreds of stocks, so is it possible to put them into the var statement in a manner other than typing each one of them? ... View more

Hi Hai, my idea is exactly the same thing as you did in your have data and your code. The only difference is that in my original data I have dates in form ddmmyy10. and for each stock there is one end-of-the-month date, but the actual day might be different for each stock: some have it on the 29th, some on the 30th and some on the 31st. Since I also wanted to do groupings I created date2 in format monyy7. in order to discard the day I redid your new code but still get 0 observations Thats the thing that I hate about programming, these little nuances which are hard to find and which stop the whole process!!! ... View more

OMG it actually worked!!! its just that in my actual data the variable price is called "prc" and since I used the cide with "price" I was getting empty columns because the variable "price" doesn't exist in my actual data :smileylaugh:  ... View more

Redid it, but now the price, last price, return columns are empty for all of the rows ... View more

I think that I realized why your code works good on your created data and not for me: my initial dates are in ddmmyy10. format and from them I created date2 which is in monyy7 format, so is it possible to make an accommodation for this? thanks! ... View more

Oh I think that I see, the thing is that my initial data has dates in the ddmmyy10 format which I after transformed into monyy7 (because I wanted to create categories) ... View more

Hi RW9, When I run your code I get an error message that the function STRIP should have a character argument. I guess that instead of STRIP I should use a function which can take dates, could you please hint which one it is? Thanks! ... View more