The programs is as folows:

------------

PROC IMPORT OUT= Mydislib.sheet1 
DATAFILE= "C:\Documents and Settings\Administrator\Desktop\S
ASData\Owner2105\rawdatamerged.xls" 
DBMS=EXCEL2000 REPLACE;

sheet=sheet1;


GETNAMES=YES;
RUN;

PROC IMPORT OUT= Mydislib.sheet2 
DATAFILE= "C:\Documents and Settings\Administrator\Desktop\S
ASData\Owner2105\rawdatamerged.xls" 
DBMS=EXCEL2000 REPLACE;

sheet=sheet2;


GETNAMES=YES;
RUN;


data Mydislib.merged;
merge Mydislib.Sheet1 Mydislib.Sheet2;

run;

data Mydislib.merged;
set Mydislib.merged;
if marketvalue__000S_ = 9999 then delete;
run;

-------------