Yeah, You are right, Tom. I can make it a permanent file so that I can look at it easily. should have done that earlier. Thanks for reminding me. I will also read the blog you shared. Thank you. Basically, I am debugging a macro written by somebody else. The problem is: There is a macro variable in the macro. The macro variable is created from the temp fileref. This particular macro variable will only resolve if you run the macro two or more batches together. For example: if you do % themac (data1); it will not resolve for data1. if you do % themac (data1); % themac (data2); % themac (data3); it will resolve correctly for data2 and data3, but not for data1. The only way to get it resolved for data1 is to change the order of the runs, like, % themac (data2); % themac (data1); % themac (data3); In this case, again it will not resolve for data2. I will keep working on this issue recently. I don't have a sample macro to show this problem yet. I may make one later and ask for extra help here. ... View more

Hi, ALL, Thanks for your inputs. Your codes work if I run SAS on my computer. However, I still have no idea where to find it if it is run on the server. But by checking what is going on inside the local computer I know what to do next. Thanks. Joe ... View more

To Arthur, I am running EG on server, and after run the codes %let pgmpath = %sysfunc(pathname(lst_out)); %put &pgmpath; , I got this path in the log /SASWork/SAS_workA48102BC003A_ualbsasapp1/#LN00093 So, How to locate this file and maybe open it (what kind of format is it)? Thanks. ... View more

Thank you Keshan. In my case, the current month means the most recent month on book. However, I think your code provide solution to another case scenario. I will save it for later. ... View more

Thanks. This is a better solution to my situation. ... View more

thank you, that helps. ... View more

Thank you all. I got it now. ... View more

Hi, I have some follow_up questions. I am trying to put it in a macro, don't know why it is not working. Can somebody offer some suggestions? Thanks. %macro one; data want;    %do month = 1 %to 19;       qtr=  (ceil( month/3)) ;       semi_year=  (ceil(month/6));       year= (ceil( month/12));       output;    %end; run; %mend; %one; ... View more

Hi, ballardw, You made it look so easy. I learned sth new. Thank you. Joe ... View more

Thanks for Arthur's additional comments. I really learned something from you guys. ... View more

Hi, ALL, Thanks for you quick help on this topic. I personally think the array one works the best for my situation and beyond (e.g. when you have character variables instead of numeric ones in this case). All other responses helped to solve my problem. Thank you all. Joe ... View more