Hello Chris

Nice post, I came across this while I was searching for how to export SASdatasets in excel 2007.

Here is the part of Code

proc export data=PathName.TestDataset
dbms=xls
outfile="E:Conversion_Projectchartstest1.xls";
sheet=test2;
run;

The problem is it doesn't recognize keyword 'xls' with dbms. Other keywords like 'excel', 'excel2003' or 'excel2008' also don't work. I even don't know whether my SAS (9.1.3 for windows) supports exporting to excel at all.

Hope you find time to reply to this.

Thanks and Regards
Gaurav