Hi, First, sorry for posting if this is the wrong place! I'm trying to learn macros better, well macros at all, and I was just given this project that would probably be made simpler by using macros. I need to do a bunch of cross tabs of variables that are in the same dataset. I have a dataset that contains the list of variables to cross tab. For example: Variable 1 Variable 2 state year age category own pets I wrote code, which I think pulled in the two sets variable names: data _null_; set all; call symput("var1", variable_1); call symput("var2", variable_2); run; Then I wrote my Proc Freq code: proc freq data=vars; tables (&var1.)*(&var2.) /norow nocol nopercent missing; run; The code runs, except that it only outputs the last crosstab. In this case (using fake variable names), age category by own pets. I would like all of the crosstabs to be generated by row, not just the last one. What am I doing wrong? Or would an array work better? Any thoughts/suggestions would be much appreciated! Thanks in advance for your help!
... View more
