topic exporting to excel in New SAS User

exporting to excel

sasthalie — Wed, 25 Aug 2021 16:07:47 GMT

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

Re: exporting to excel

ballardw — Wed, 25 Aug 2021 16:16:47 GMT

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.