topic Export Excel code Lesson 6 in Programming 1 and 2

Export Excel code Lesson 6

Sassy_lady — Tue, 18 Oct 2022 00:25:21 GMT

This is the code generated from the lesson and it opens in Excel

ods excel file="&outpath/StormStats.xlsx"
    style=snow
    options(sheet_name='South Pacific Summary');
ods noproctitle;

proc means data=pg1.storm_detail maxdec=0 median max;
    class Season;
    var Wind;
    where Basin='SP' and Season in (2014,2015,2016);
run;

ods excel options(sheet_name='Detail');

proc print data=pg1.storm_detail noobs;
    where Basin='SP' and Season in (2014,2015,2016);
    by Season;
run;

ods excel close;
ods proctitle;

This is the code that I created and it doesn't open in Excel

ods excel file="&outpath/StormStats.xlxs"
 style=snow
 options(sheet_name='South Pacific Summary');
ods noproctitle;

proc means data=pg1.storm_detail maxdec=0 median max;
    class Season;
    var Wind;
    where Basin='SP' and Season in (2014,2015,2016);
run;

ods excel options(sheet_name='Detail');

proc print data=pg1.storm_detail noobs;
    where Basin='SP' and Season in (2014,2015,2016);
    by Season;
run;
ods excel close;
ods proctitle;

I'm not sure what I am doing wrong.

Re: Export Excel code Lesson 6

Tom — Tue, 18 Oct 2022 02:24:34 GMT

What do you mean by does not open?

Did you expect it to automatically start Excel for you? How are you running the SAS code? Are you running SAS on your PC? Or are you using some front end tool to submit the SAS code, such as Enterprise Guide or a browser connected to a SAS/Studio installation?

Or did you actually try to open the resulting file with Excel and it did not work? What error message did Excel give?

Did the SAS log have any error messages? Did the PROC steps actually produce output? Perhaps none of the observations met the WHERE condition you imposed. That would create an empty XLSX file, which would not be readable by Excel.

Re: Export Excel code Lesson 6

ballardw — Tue, 18 Oct 2022 05:04:50 GMT

What does your log show when you run the code?

When you get unexpected behavior it is best to copy the text from the LOG and then paste the log text into a text box.

You might find issues with file paths, such as does not exist or invalid. Did you update the OUTPATH macro variable? without a correct value then the file system doesn't know where you intend to write the file.

Have you created all the data sets from the course set up instructions?

Re: Export Excel code Lesson 6

coder1234 — Wed, 19 Feb 2025 19:57:01 GMT

Were you able to resolve the issue?

Re: Export Excel code Lesson 6

OleSteen — Fri, 03 Oct 2025 14:22:26 GMT

My guess is that you have misspelled the name of your Excel file extension (xlxs) which are not associated with MS Excel