Help using Base SAS procedures

Saving .csv as .xlsx file using SAS

Reply
Frequent Contributor
Posts: 127

Saving .csv as .xlsx file using SAS

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

Super User
Posts: 3,257

Re: Saving .csv as .xlsx file using SAS

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. 

SAS Super FREQ
Posts: 8,868

Re: Saving .csv as .xlsx file using SAS

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

Ask a Question
Discussion stats
  • 2 replies
  • 501 views
  • 0 likes
  • 3 in conversation