Sorry for my late response, but thank you for your help! My table produced error with your suggested code, but I think it's my table's issue.. It doesn't make sense that my table doesn't accept data step but it runs with SQL without any error ... I'm sure your code will be useful to others and next time I encounter similar issue using different SPSS file. Thanks again!!  ... View more

Thank you RW9! This worked for me!!  ... View more

Reeza, thanks for your quick response! You are absolutely right! Although I thought the forecastdate has been converted to character by put function.. but the code finally works and I'm so happy!! Thank you very much for your help!!! Ballardw and Slchen, I also want to thank you for your advice!! ... View more

Hi, thanks for your quick response! It worked perfectly and yes, I will review the SAS documentation once again. Hatsumi ... View more

Hi Xia, Thank you for your response! I ran your codes and it runs beautifully!! The number of stores changes from time to time, so I am very happy with your codes because I only need to update an array function when I retrieve the sales data. I really learn a lot from all of you, so thanks again! Best, Hatsumi ... View more

Hi Xia This is great!!! Thank you so much!!! Although I knew all the functions you used, I never thought of using them to make the code simpler.. I guess it takes a lot more practice. Thanks again! Hatsumi ... View more

Please read the answer marked 'correct' carefully, run the code, try to understand the outcome.  For catx, catt, you need to read the manual on how they process the variable content (especially on how they treat the trailing blanks) during the concatenation. Answers are all there for a prepared pair of eyes. ... View more