topic Create XLSX in SAS Content Folder in SAS Programming

Create XLSX in SAS Content Folder

Luhan — Fri, 05 Jul 2024 12:25:32 GMT

Hi,

as described here in example 3, it's fairly easy to save a data file as CSV in a SAS content folder, e.g. sashelp.class:

Is there any procedure or method to save the data file as XLSX in a SAS content folder?

Thanks

Luhan

Re: Create XLSX in SAS Content Folder

Kurt_Bremser — Fri, 05 Jul 2024 13:03:50 GMT

Have you tried PROC EXPORT with DBMS=XLSX or ODS EXCEL, using the same file designation in the FILE= option?

Re: Create XLSX in SAS Content Folder

Luhan — Fri, 05 Jul 2024 13:28:11 GMT

Thanks for the suggestion @Kurt_Bremser !

Clear case of having had a way too busy week. Could have sworn that the following syntax created just a CSV file named class.xlsx earlier, but it's actually a real XLSX!