DATA Step, Macro, Functions and more

Compare ID statement

Reply
Contributor
Posts: 36

Compare ID statement

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

 

Trusted Advisor
Posts: 1,586

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: 7,861

Re: Compare ID statement

Read the very fine SAS documentation for proc compare: http://support.sas.com/documentation/cdl/en/proc/69850/HTML/default/viewer.htm#n1nwxbchh5hpu1n1h28km....

It includes examples.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 2 replies
  • 130 views
  • 1 like
  • 3 in conversation