11-19-2017 03:16 PM
Tabulate is usually used when you want to summarize data. There's nothing indicated in your requirements that show the need for summarization. This would be better suited to PROC REPORT or PRINT.
PROC TABULATE also would need a statistic, here's an example of PROC TABULATE.
proc tabulate data=class; by sex; class name age height; table name*age*height , N ; run;
11-19-2017 03:18 PM
What's your "location"? Dept, city or zone, or some combination?
Basically, what you want is a proc print with by.