About Binxie

Binxie · ‎07-29-2019

Yes, I have outdif and outnoequal in my query. There are actually 400,000 difs in the data. proc compare base=recs_a compare=recs_b out=result outnoequal outbase outcomp outdif noprint; id POLICY_NUMBER TERM_NUMBER POLICY_RISK_IDENTIFIER EFFECTIVE_FROM EFFECTIVE_TO; run;

Binxie · ‎07-29-2019

These are actual differences. The two data sets need to be identical. It's a new view that was created from an old one, and we are testing that the landed data is matching as the business expects it to.

Binxie · ‎07-29-2019

Yes, I'm outputting it to a data set. The problem is because there is over 400,000 records and 350+ columns, I don't know the best way to find the differences. How do I easily identify, by the Primary key, which columns have the differences without scrolling thru 400,000 rows and 350 columns.

Binxie · ‎07-29-2019

I can view the output fine. I just need the ability to identify the differences easily. Currently there are over 400,000 rows and in the 350+ columns there could be differences. I'm just trying to identify, by the ID which records in which columns have differences. If I could export, it would be easier to analyze, but I can't so I'm trying to figure out a way to just output by ID the column where the dif=XXX.

Binxie · ‎07-29-2019

Hello I have a two extra large data sets (>9Million records) that I'm am trying to compare. The data sets have over 300 columns in them. I was able to run a proc compare that outputs the differences only by ID, however, because of the size of the data set and the restrictions on exporting at my company, I cannot get the data out to analyze on a record by record basis which columns are not matching. Is there an easy way in SAS that I can only show the variables (by the ID key) that are different? Any other suggestions on how I can view only the differences in the individual columns? Thanks

Binxie · ‎07-10-2018

Worked perfectly! Thanks so much!

Binxie · ‎07-10-2018

Hello SAS Community, I'm a relatively newbie and I'm hoping you can help me. I have a dataset that has multiple columns that are in a date format. I need to confirm if all dates in the columns are the same, or if one or more of them are different. If any column has a different value I wish to set a flag that indicates this. Is there an easy way to do this? See my sample data and expected output below. Thanks in advance! Data example: ACCOUNT COL1 COL2 COL3 COL4 COL5 COL6 COL7 COL8 COL9 1 9-Jun-18 9-Oct-18 9-Jun-18 2 9-Jun-18 9-Jun-18 3 9-Jun-18 9-Jun-18 9-Jun-18 9-Apr-18 9-Jun-18 9-Jun-18 9-Jun-18 9-Nov-18 9-Jun-18 4 9-Aug-18 9-Jun-18 9-Jun-18 9-Jun-18 9-Jun-18 5 9-Jun-18 9-Jun-18 I would like to output as follows: ACCOUNT COL1 COL2 COL3 COL4 COL5 COL6 COL7 COL8 COL9 FLAG 1 9-Jun-18 9-Oct-18 9-Jun-18 different 2 9-Jun-18 9-Jun-18 same 3 9-Jun-18 9-Jun-18 9-Jun-18 9-Apr-18 9-Jun-18 9-Jun-18 9-Jun-18 9-Nov-18 9-Jun-18 different 4 9-Aug-18 9-Jun-18 9-Jun-18 9-Jun-18 9-Jun-18 different 5 9-Jun-18 9-Jun-18 same

Online Status	Offline
Date Last Visited	‎07-31-2019 05:06 PM

Re: Proc Compare Large dataset with many columns

Re: Proc Compare Large dataset with many columns

Re: Proc Compare Large dataset with many columns

Re: Proc Compare Large dataset with many columns

Proc Compare Large dataset with many columns

Re: Compare Multiple Column date values

Compare Multiple Column date values

Re: Proc Compare Large dataset with many columns

Re: Proc Compare Large dataset with many columns

Re: Proc Compare Large dataset with many columns

Re: Proc Compare Large dataset with many columns

Proc Compare Large dataset with many columns

Re: Compare Multiple Column date values

Compare Multiple Column date values