In this previous blog, I conducted a Q&A interview with SAS instructor Theresa Stemler about the new Exporting SAS Data Sets and Creating ODS Files for Microsoft Excel course that she recently developed. Since teaching the new course, Theresa has responded to several questions from students and wanted to share these two tips, which you may find helpful:
Dear Instructor,
I have been using the ODS destination of EXCELXP to send my procedure output to a file that can be opened in Excel. I really like the EXCELXP destination because it creates multiple sheets in my workbook. However, I want to send some SAS/GRAPH procedure output to the file. The SAS/GRAPH output does not work with the EXCELXP tagset. Any thoughts on what I should do?
Dear Student,
Have you heard of the MSOFFICE2k destination? ODS MSOFFICE2K creates an HTML file that can be opened in Excel. This destination does not create multiple sheets but there is a spin-off of this destination that does create multiple sheets. The destination is called SOFFICE2K_X. This destination is not automatically included in SAS 9.3 but you can download the destination. Find more information on the MSOFFICE2K_X destination. This destination is covered in the Exporting SAS Data Sets and Creating ODS Files for Microsoft Excel course.
Dear Instructor,
PROC EXPORT, the LIBNAME statement, ODS. I'm confused to what is the best method to use. Can you help shed a little light?
Dear Student,
It all boils down to what you want to Export. If you want to export a SAS data set, you can use either PROC EXPORT or the LIBNAME statement. If you want to export SAS procedure output, then you will want to investigate the ODS methods. The Exporting SAS Data Sets and Creating ODS Files for Microsoft Excel course discusses the different methods and their requirements. The course also covers a long list of options for customizing your file.
If you need to learn more about getting your SAS data output into Excel, don’t miss registering for the new course. View course dates for Exporting SAS Data Sets and Creating ODS Files for Microsoft Excel course.
