topic Re: Table creation for compared data in SAS Enterprise Guide

Table creation for compared data

radha1 — Mon, 03 Sep 2018 13:49:31 GMT

Hi,

I compared two data sets, want to keep the compared data in one table.

can anyone help me how to display compared data in tabular format in SAS EG.

Thanks in Advance.

Re: Table creation for compared data

RW9 — Mon, 03 Sep 2018 13:53:00 GMT

From the manual:

http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#n1f136xdchlfrtn1663tmzklctb6.htm

specify out=

and give a dataset name to store the output.

Re: Table creation for compared data

VDD — Mon, 03 Sep 2018 14:29:13 GMT

Please post the SAS code that you are having problems with. Also include you SAS log.

Lots of SAS code and examples are available online, but you should show your attempts at resolving the problem first so that the experts can help guide.

Re: Table creation for compared data

Astounding — Mon, 03 Sep 2018 14:55:41 GMT

If you are not getting much of a response to your question, it's probably because you left out most of the important information. Here's what you should describe, and not leave to our imagination.

"I compared two data sets"

Are they SAS data sets?
How did you compare them?

"want to keep the compared data"

All the data was compared. So what exactly do you want to keep? Give the details. All of them.

"in one table"

In one Excel spreadsheet? In one SAS data set? In one DMBS table?

"display the compared data"

At this point, nobody knows what the compared data is, and nobody knows what type of display you would like.

Re: Table creation for compared data

radha1 — Tue, 04 Sep 2018 07:07:37 GMT

Thanks for the response,

how to print proc compare results as table or html.

the below data have display in html or table format:

Variables Summary
Number of Variables in Common: 3.
Observation Summary
Observation Base Compare
First Obs 1 1
Last Obs 4 4
Number of Observations in Common: 4.
Total Number of Observations Read from
WORK.DEMOG: 4.
Total Number of Observations Read from
WORK.COMPARE: 4.
Number of Observations with Some Compared Variables
Unequal: 0.
Number of Observations with All Compared Variables
Equal: 4.
NOTE: No unequal values were found. All values
compared are exactly equal.

Thanks

Re: Table creation for compared data

Astounding — Tue, 04 Sep 2018 12:55:44 GMT

The most flexible way would add this statement before running PROC COMPARE:

ods trace on;

Then you can see notes in the log about all the pieces of output that ODS stores. You can capture the ones you want as SAS data sets using multiple ODS OUTPUT statements.

Each piece can then be printed using a simple PROC PRINT. You can add as much formatting as you would like, when it comes time to print.