|Date: ||Mon, 1 Jul 2002 22:43:52 GMT|
|Reply-To: ||VCHAYDEN <vchayden@AOL.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||VCHAYDEN <vchayden@AOL.COM>|
|Organization: ||AOL http://www.aol.com|
|Subject: ||Re: Sql v. datastep|
It's not just that it's Monday... I don't know any way to get that in one step
in SQL (would love to hear one).
You can at least substitute LEFT for INNER to get the ina dataset, then reverse
the process & combine the results.