proc sql;
create table WORK.Validations2 as
select distinct Lease_Type_Desc
from WORK.Validations1
group Lease_Type_Desc;
run;
proc export
data=VALIDATIONS2
dbms=EXCEL2000
outfile="C:\temp\prdsale.xlsx"
replace;
run;

I got the output Data but file is not being created.