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

Quartz | Level 8

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

Posted 10-14-2010 02:49 PM (1703 views)

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?

1 REPLY 1

Quartz | Level 8

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

Posted 10-14-2010 03:12 PM (1652 views) | In reply to SASPhile

Got it:

group by variable name
having count(*)>1

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!

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

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

Registration is open

Call for Content EXTENDED

SAS Training: Just a Click Away