comapre cols

a13 — Mon, 03 Sep 2018 08:27:45 GMT

I want to compare two datasets from different libraries, basically i want to look for values in the datasets which are different. Please help me write the query. I am confused between using except corr and except all.

Re: comapre cols

RW9 — Mon, 03 Sep 2018 08:36:20 GMT

In what sense? Do you mean a row by row comparison, by certain identifiers, by distinct lists of values? Post some example test data in the form of a datastep:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

And what the output should be like.

All I can say from what you have posted is that there is a procedure called proc compare which is for comparing datasets. Other than that I know nothing of your problem.

topic Re: comapre cols in SAS Studio

comapre cols

Re: comapre cols