DATA Step, Macro, Functions and more

sql equivalent of first.variable not equal to last.variable

Reply
Super Contributor
Posts: 647

sql equivalent of first.variable not equal to last.variable

in datastep if we want to select all those not distinct records first.variable ne last.variable logic can be applied.
Is there an equivalent in proc sql?
Super Contributor
Posts: 647

Re: sql equivalent of first.variable not equal to last.variable

Got it:

group by variable name
having count(*)>1
Ask a Question
Discussion stats
  • 1 reply
  • 304 views
  • 0 likes
  • 1 in conversation