topic Re: Proc compare : maxprint in SAS Programming

Proc compare : maxprint

Moise — Fri, 16 Jun 2023 15:47:29 GMT

Hello,

I have to compare 2 large datasets using proc compare with printing the results. I used the code below

Proc compare base=tab1 comp=tab2 ; id anonymat gender; run;

But I have this warning message for all the variables not in ID statement

Note: The MAXPRINT=50 printing limit has been reached for the variable birthdate. No more values will be printed for this comparison

How to solve it?

Thanks

Re: Proc compare : maxprint

Reeza — Fri, 16 Jun 2023 15:50:10 GMT

Don't print the results - use the output data sets instead.

Re: Proc compare : maxprint

SASKiwi — Sun, 18 Jun 2023 00:09:16 GMT

How many differences does your COMPARE difference summary report? You can use the MAXPRINT option to print more differences but beyond a few hundred the output gets too large an other techniques become more useful.

Re: Proc compare : maxprint

ballardw — Sun, 18 Jun 2023 15:05:43 GMT

You may need to sort by more variables than the ID variables if there multiple values of the ID var combinations.

Re: Proc compare : maxprint

Tom — Sun, 18 Jun 2023 15:48:05 GMT

The NOTE is telling you want to do.

Add the MAXPRINT= option to the PROC COMPARE statement.

Re: Proc compare : maxprint

Moise — Tue, 20 Jun 2023 08:02:54 GMT

Thank you very much MAXPINT= was the solution to my problem.