DATA Step, Macro, Functions and more

Compare ID statement

Posts: 41

Compare ID statement

Can someone explain me Compare procedure ID statement use with simple example.


Trusted Advisor
Posts: 1,849

Re: Compare ID statement

[ Edited ]

Do you mean using proc compare ?


Let have:

data A with 

       ID   VAR1

        1     25

        2     33


data B with

       ID  VAR1

        2     20

        3     50


Without ID statement comparison will be first row of A with first row of B etc.

With ID statement caomparison will be

             A ID=1 with no parallel in B

             A ID=2 with B  ID=2     etc.

Super User
Posts: 10,623

Re: Compare ID statement

Read the very fine SAS documentation for proc compare:

It includes examples.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 2 replies
  • 1 like
  • 3 in conversation