Help using Base SAS procedures

Creating a Tabulate format

Reply
New Contributor
Posts: 2

Creating a Tabulate format

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. 

 

Untitled.png

PROC Star
Posts: 1,283

Re: Creating a Tabulate format

Posted in reply to Debashish_

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

New Contributor
Posts: 2

Re: Creating a Tabulate format

aaaaa.png

Super User
Posts: 23,776

Re: Creating a Tabulate format

Posted in reply to Debashish_

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. 

 

Screen Shot 2017-11-19 at 1.14.07 PM.png

 

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;
Super User
Posts: 10,280

Re: Creating a Tabulate format

Posted in reply to Debashish_

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

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 4 replies
  • 135 views
  • 0 likes
  • 4 in conversation