Proc compare help needed

[bhasan01]

When using outnoeqaul options in the output dataset in proc compare procedures it takes more space to store all the not eqaul data in o/p in the case of huje dataset.

lets say I have 10 crores of data in dataset.

appreciate your help.

[RW9]

Sorry, I have absolutely no clue as to what the question is.  Read the information below the post button on new questions and the box the pops up.  Show example test data in the form of a datastep, what you want to see out, and any logic in between.

[Kurt_Bremser]

---

@bhasan01 wrote:

When using outnoeqaul options in the output dataset in proc compare procedures it takes more space to store all the not eqaul data in o/p in the case of huje dataset.

lets say I have 10 crores of data in dataset.

appreciate your help.

---

Surprise!

You asked for more output, you got more output. That's it.

[ballardw · Accepted solution]

If you do not expect a lot of "noequals" results it may be that the two data sets are not in the same order. Sometimes sorting both of the data sets results in fewer mismatched data points.

You may also want to post the exact code you are using as other options may be affecting the result.

And possibly you data  is just not a similar as you thought.

[bhasan01]

Hi ,

Thanks for the comments

My source data set are already sorted on ID column,

Please refer my sample code

Proc compare base=one compare =two out=three outnoeqal;
Id var1;
Run;



I need any idea that can restrict to more data in output dataset .

Note that I need to have output dataset as the o/p need to send to other party...

Thanks
Bhasan01