Hi
Actually I want to sub set my data with the following program
data final.abc;
set abc;
where date = '30Dec2010" d and customerNo in (select custno. from salesdata);
run;
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.
regards
Mars
... View more