The table above is what I'm trying to achieve. Basically it's just a simple pivot table with the months on the column and some variables on the left. Note that some of the variables can be broken down. For example, variable Spend can be broken into LCY and FCY. The reason for MACRO is that, I'd need to recreate the same table for another `types`. You can imagine that above table is about FRUITS in general. I'd like then to recreate the same table but for APPLE. So far, I've been using PROC SQL to calculate the sum(), count(), etc and then use PROC TRANSPOSE to get the time series or pivot table as above. Though, I like to believe that SAS would have somthing more simpler to generate this kind of report :). Would be very glad if you know how.
... View more