Right, what Reeza said.  Regardless of how you process your initial dataset (e.g. proc freq, with/without ODS output saved, or calculating them using proc sql, import via excel, etc.) then you can run this procedure on your resulting dataset.  ... View more

I am not sure about your questions but you can adjust the macro to generate any SAS code that you can figure out.   From your use of the FORMAT statement in the PROC TABULATE code I assumed that the values were already stored as the abbreviations and that the format STATE that you mentioned would cause the longer state name to be used in the report.   If the values in the data have full state names ('Alabama', 'New York', etc.) and you want to support passing multiple values into the macro then you will need to adjust the logic to use some other separator than a space in the list of values.   Or you could use formats or functions to convert between code and state name so that you could still pass in the shorter value.   You should look at some of the functions that SAS has for handling FIPS codes.  Like FIPSNAME() and STFIPS().   ... View more