exporting to excel

[sasthalie]

Hi,

I'm trying to use proc export on SAS OnDemand to export a dataset to Excel. However, the file only shows up with .bdat extension in my "My SAS files" on my SAS server. How can I have it show up with .xlsx then download it? 

Here's what I have used 

proc export data=
dbms=xlsx
outfile=" "
replace;
run;

Thank you

[ballardw]

Best way to ask questions is often to include the actual log entry with the code and any notes.

Then we can tell if your output file name is appropriate. A very common problem is not including the full path for the file and the result, if created, appears somewhere other than expected.

Your code would not generate anything, no input data set, no output file name so not particularly helpful.