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.
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.
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.
@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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.