@Gauri123-56 wrote: Yes I have this code using proc report but I want to do this using macros...
Bullshit. Macros are for creating dynamic code, not for creating reports. As others have already suggested, you need to first become deeply familiar with data step programming and the use of essential procedures (SORT, REPORT, MEANS, FREQ, TABULATE, SQL, TRANSPOSE, to name just a few) before you can even think about macro programming.
And if you are already at the step where you have working code and want to make it dynamic, you need to show that code, and which parts of it need to be made dynamic, and the information on which the dynamics are based (e.g. a dataset which contains control information).
... View more