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
Have you tried PROC EXPORT with DBMS=XLSX or ODS EXCEL, using the same file designation in the FILE= option?
Have you tried PROC EXPORT with DBMS=XLSX or ODS EXCEL, using the same file designation in the FILE= option?
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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.