how to combine multiple column table to one column in result proc tabulate in sas Enterprise guide

[merahilyana]

How to get the result table1  be like table2 in sas eg

table1:

table3:

[PeterClemmensen]

It's really hard to understand how your data is actually structured from this. Please provide data in a clear, usable form (preferably in the form of a data step)

[merahilyana]

WHAT I MEAN IS:

       from this table in result sas EG 

state and administrative district
Johor
	Batu pahat
	Muar

to get like this table result sas EG

state and administrative district

Johor

Batu pahat

Muar

that is different variable name. state: johor and administrative district: batu pahat and muar.

[Reeza]

Please post example data if you would like assistance with the code. 

Your images show the variables being in the same column. 

Here are instructions on how to provide sample data as a data step:
https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

---

@merahilyana wrote:

WHAT I MEAN IS:

       from this table in result sas EG 

state and administrative district
Johor
	Batu pahat
	Muar

to get like this table result sas EG

state and administrative district

Johor

Batu pahat

Muar

that is different variable name. state: johor and administrative district: batu pahat and muar.

---

[ballardw]

Do you mean the appearance inside a data set with viewtable or similar tool? Or a report table generated for people to read by a report procedure such as Proc Report, Tabulate or something else?

One approach may be multilabel formats for a report such as shown in the attachment examples.

[Reeza]

PROC REPORT with journal style will give you that report.

---

@merahilyana wrote:

How to get the result table1  be like table2 in sas eg

table1:

table3:

---