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!
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.