topic Re: Saving .csv as .xlsx file using SAS in SAS Procedures

Saving .csv as .xlsx file using SAS

pp2014 — Wed, 22 Oct 2014 19:14:26 GMT

I have .csv file which I want to save as .xlsx file. I want to keep the original .csv file as it is but kind of copy .csv into .xlsx. I am using the following. It copies .csv file into .xlsx but I cannot open that .xlsx file. options xsync noxwait; x %sysfunc(quote(copy "c:\temp\test123.csv" "c:\temp\test123.xlsx")) ; Is there a way I can copy .csv into .xlsx file using sas? Thanks

Re: Saving .csv as .xlsx file using SAS

SASKiwi — Wed, 22 Oct 2014 19:35:45 GMT

I don't see the point of simply copying a CSV and renaming it with an XLSX extension. The copy is still a CSV file even though the extension indicates it is an XML-type spreadsheet.

Is it your intention to create a genuine XLSX spreadsheet copy of the CSV? If so you can do that in a variety of ways from SAS including PROC EXPORT and ODS ExcelXP tagset.

Re: Saving .csv as .xlsx file using SAS

Cynthia_sas — Wed, 22 Oct 2014 20:40:39 GMT

Hi:

A minor correction. ODS and TAGSETS.EXCELXP do not create a "genuine" XLSX spreadsheet. TAGSETS.EXCELXP creates Spreadsheet Markup Language XML (designed for Office 2003), which was the XML precursor to the XLSX format. PROC EXPORT can create true XLSX files. There is a new ODS destination on the horizon that will also create XLSX files, but it is still pre-production, as described here: http://blogs.sas.com/content/sasdummy/2014/09/21/ods-excel-and-proc-export-xlsx/

cynthia