Write and run SAS programs in your web browser

Proc compare help needed

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Proc compare help needed

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.


Accepted Solutions
Solution
a month ago
Grand Advisor
Posts: 10,043

Re: Proc compare help needed

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.

View solution in original post


All Replies
Esteemed Advisor
Esteemed Advisor
Posts: 6,977

Re: Proc compare help needed

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.

Esteemed Advisor
Posts: 6,268

Re: Proc compare help needed


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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Solution
a month ago
Grand Advisor
Posts: 10,043

Re: Proc compare help needed

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.

New Contributor
Posts: 2

Re: Proc compare help needed

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
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 89 views
  • 0 likes
  • 4 in conversation