topic Re: how to combine multiple column table to one column in result proc tabulate in sas Enterprise gui in New SAS User

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

merahilyana — Tue, 27 Aug 2019 10:06:18 GMT

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

table1:

table3:

Re: how to combine multiple column table to one column in result proc tabulate in sas Enterprise gui

PeterClemmensen — Tue, 27 Aug 2019 10:12:01 GMT

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)

Re: how to combine multiple column table to one column in result proc tabulate in sas Enterprise gui

ballardw — Tue, 27 Aug 2019 14:26:02 GMT

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.

Re: how to combine multiple column table to one column in result proc tabulate in sas Enterprise gui

Reeza — Tue, 27 Aug 2019 16:00:11 GMT

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:

Re: how to combine multiple column table to one column in result proc tabulate in sas Enterprise gui

merahilyana — Wed, 28 Aug 2019 03:44:18 GMT

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.

Re: how to combine multiple column table to one column in result proc tabulate in sas Enterprise gui

Reeza — Wed, 28 Aug 2019 14:14:08 GMT

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-data-AKA-generate/ta-p/258712

@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.