I created a library for this next project I am working on, and within it there will be 12 tables--one representing each month. The goal is to see month-to-month the rate of change for each field. I have researched, and tried a few things and have had no luck. I am hoping to have it as an easily accessible/exportable finalize report. I visualized having the table names (months) as the rows, and the column headers as the name of each field (they will be the same month to month). I know I can use proc tabulate for this, but I am struggling with how to represent the change factor for each field from month to month. The field data is mostly qualitative data I am new to the board, so please let me know if more info is needed. Any ideas? Thank you in advance, any help is greatly appreciated! Macro preferred, any help appreciated! Idea 1: Fields Months Field 1 Field 2 etc..... Jan to Feb 100% 80% Feb to Mar 0% 50% Mar to Apr 20% 100% etc.. Idea 2: Fields Months Field 1 Field 2 etc..... Jan to Feb Changed Not changed Feb to Mar Not Changed Not Changed Mar to Apr Changed Changed etc..
... View more