@GurmeetKaur_23 wrote: Hey There,   Yes, I asked the question there on stackoverflow as well. But dont you think there could be some reason why I posted it again here? Might be that I had some more queries or might be the reason that no body would have posted the answer on stackoverflow when I posted my query here. There would have been a reason other wise why would I have put the same question here. No?   I think one should better be asked reason before being pointed to on such a public forum.     That's exactly what I did, l asked the reason.  Is there something there that doesn't make sense to you?   @GurmeetKaur_23 Considering you hadn't bothered to ask any clarifications or acknowledge the answer on the other post with someone who took the time to answer your question, I'm fine with pointing out that you posted it elsewhere and asking why that post did not meet your needs or what was unclear.      ... View more

Thank you ballardw. Thanks a lot for helping me with the fact that "No, you can't use arrays. In SAS arrays work on a single row, not on columns. They're considered a shortcut reference to variables but not an array in the sense of matrix/arrays. If you really want to use arrays, you'll need to use IML and matrix language. "   Also, the solution that you gave is working as expected. Really, thanks a lot. ... View more