Create XLSX in SAS Content Folder

[Luhan]

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

[Kurt_Bremser · Accepted solution]

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

[Luhan]

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!