Hello, I have a table of Producer Price Indices (PPI) in excel(attached). I would like to create a macro to move all the rows into one row, so there is one row with each of the months in chronological order. And I would like to add the year next to each month. I cannot for the life of me figure out how to do this. The problem I'm having is adding the year to each month. If you can think of a better macro or correct mine I would really appreciate it. Here's what I have so far. %MACRO PPI_NEW(YEAR, PPI); PROC SQL; INSERT into PPI_COMB ( YEAR&YEAR , /* I am not sure this will work*/ Jan&YEAR , /* I want tohave the fields update with the macro */ Feb&YEAR , Mar&YEAR , April&YEAR, May&YEAR , June&YEAR , July&YEAR , Aug&YEAR , Sept&YEAR , Oct&YEAR , Nov&YEAR , Dec&YEAR ) SELECT ( YEAR, January, February, March, April, May, June, July, August, September, October, November, December ) FROM PPI_&PPI WHERE YEAR = &YEAR; QUIT; %MEND;
... View more