topic How to show 2 tables corresponding with each other in excel sheet using ods excel ? in ODS and Base Reporting

How to show 2 tables corresponding with each other in excel sheet using ods excel ?

salman1208 — Wed, 16 Jan 2019 11:29:18 GMT

How to show 2 tables corresponding with each other in excel sheet .

example:- there are 2 tables. table1 and table2. I want these two in excel sheet. corresponding with each other.

Table1 in left side and table2 in right side.

Is it possible using ods excel or other source ?

I have attached excel for example.

Re: How to show 2 tables corresponding with each other in excel sheet using ods excel ?

PeterClemmensen — Wed, 16 Jan 2019 11:56:58 GMT

Welcome to the SAS communities 🙂 Yes, this is possible with the ODS EXCEL Destination.

Are your SAS tables of fixed size or can they vary in terms of number of observations and variables?

Definitely check out the START_AT Option in the ODS Excel Statement. The blog post Tips for Using the ODS Excel Destination will get you far.

Re: How to show 2 tables corresponding with each other in excel sheet using ods excel ?

ballardw — Wed, 16 Jan 2019 16:05:06 GMT

May I ask why you want these two side by side?

If the purpose is to compare the records or values you might consider investigating use of SAS Proc Compare which will examine things like number of rows, number of variables, common variables, variables only in one set, variables of same names with different properties such as value type, numeric or character, labels or formats.

It can also do a row-by-row comparison of values and report the results in a number of ways.