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 (1750 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 (1699 views) | In reply to SASPhile

Got it:

group by variable name
having count(*)>1

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

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

Registration is open

SAS Training: Just a Click Away