topic Re: Creating a Tabulate format in SAS Procedures

Creating a Tabulate format

Debashish_ — Sun, 19 Nov 2017 19:46:03 GMT

Hello,
can anyone help me out. I have attached an Image of a tabulate structure which I have tried but couldn't.

Someone tell me or share the code how to create that.

Re: Creating a Tabulate format

PeterClemmensen — Sun, 19 Nov 2017 19:47:55 GMT

What does your data look like? We can not give you a code answer if we don't know what your data looks like 🙂

Re: Creating a Tabulate format

Debashish_ — Sun, 19 Nov 2017 19:53:22 GMT

Re: Creating a Tabulate format

Reeza — Sun, 19 Nov 2017 20:16:52 GMT

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;

Re: Creating a Tabulate format

Kurt_Bremser — Sun, 19 Nov 2017 20:18:51 GMT

What's your "location"? Dept, city or zone, or some combination?

Basically, what you want is a proc print with by.