Thanks for replying. I just started learning SAS and so I am wondering if there is a way to do it. I did go through the link you shared with me but what I am trying to figure out is if I can split the data based on the Macro I call (For Example: %macroname('US', 'CA') or %macroname('CH', 'JP', 'AU', 'IN')). I am not even sure if it can be done as I have been looking for a solution for the past few days now but with no luck. Please help if you can. Thanks again.
... View more