Hello Mars,
You need something like this:
[pre]
proc SQL;
create table final.abc as
select a.*,b.* /* list all variables you need from two datasets */
from abc as a, salesdata as b
where a.date='30Dec2010'd and a.customerNo=b.Custno
;quit;
[/pre]
Sincerely,
SPR
... View more
