Date:         Tue, 7 Sep 2004 10:37:12 +0300
Reply-To:     Nina Harris <sas@MAILINATOR.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nina Harris <sas@MAILINATOR.COM>
Subject:      Re: Help required on SQL join example 2

Roger Lustig wrote:
> If the former, try:
> If the latter:

hmm.. both your solution samples produce identical output
ID=1 period=1 val=10
ID=1 period=2 val=10
ID=. period=3 val=0
ID=1 period=4 val=10