Actually I want to sub set my data with the following program
where date = '30Dec2010" d and customerNo in (select custno. from salesdata);
data set abc and and data set salesdata both exist in as a temporary data set.
I want to sub set the data not only by date (a variable in dataset abc) but also by CustomerNo( also a variable in data set abc) by setting its value equal to Custno. ( a variable in another dataset salesdata).
Can somebody please check the syntax for sas, as I am unable to run this command.
You need something like this:
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