You can correct it as follows: proc sql;
select orderid, productid,orderdate,linetotal
from Salesorders
where orderid in (select orderid from JulySales);
quit; But you should first ensure that the attributes(length, format etc) of orderID in dataset-JulySales and dataset-Salessorders are same. Hope this helps. Thanks, Fred
... View more