topic Re: Proc compare help needed in SAS Studio

Proc compare help needed

bhasan01 — Thu, 25 May 2017 12:34:17 GMT

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.

Re: Proc compare help needed

RW9 — Thu, 25 May 2017 12:52:17 GMT

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.

Re: Proc compare help needed

Kurt_Bremser — Thu, 25 May 2017 12:56:11 GMT

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

Re: Proc compare help needed

ballardw — Thu, 25 May 2017 16:43:55 GMT

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.

Re: Proc compare help needed

bhasan01 — Thu, 25 May 2017 17:37:19 GMT

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