Convert CSV to Excel With the “Save As” Option You can work with your CSV files without converting them in Excel. Note: You do not necessarily have to convert a CSV file to Excel format to open and edit it in the Excel app.

With this method, you get to configure the data type for your CSV file’s data.Įxcel also has a legacy “Text Import Wizard” to import data from files like CSV into your worksheets, but the aforementioned new methods are slowly replacing it.

The other method is to import your CSV file’s data into an Excel workbook and then save that workbook as a new XLSX file. For example, your CSV might use a certain date format, and that format might be different in Excel, which renders your data inaccurate. The drawback of this method is that it uses the default Excel data format, which might not work very well with your CSV’s data. Just look for the Export as a Step task on your data view, or the 'Share' tool in SAS Enterprise Guide 8.1.The first method is to open your CSV file in Excel and then save the file as an XLSX file. The PC Files Server is still very useful for other scenarios, such as supporting the PCFILES LIBNAME engine, which can read and write Microsoft Excel and Microsoft Access files, among others.Īnd if you're looking for a point-and-click method for creating XLSX files in SAS Enterprise Guide, we cracked that nut a while ago. (On 64-bit Windows, you can make it work with very little configuration using the 'autostart' capability.) The EXCELCS method works by delegating the Excel read/write operation to another Windows node that has a PC Files Server instance. Prior to this support, most customers who run SAS for 64-bit Windows or on a UNIX platform would need to use DBMS=EXCELCS for this operation.

Handpicked Related Content: How do I export Excel files, let me count the ways With these latest changes, you can get the job done without setting up a PC Files Server, even on systems that don't have a 32-bit Windows architecture. Remember: using the IMPORT and EXPORT procedures to read and write Microsoft Excel files requires the SAS/ACCESS to PC Files module. Kathy's tutorial includes simple shortcuts, such as using the LIBNAME XLSX engine to read Excel files just like data sets. Watch this tutorial (from SAS instructor Kathy Kiraly) to learn more about how to import and export XLSX files in SAS with just a few lines of code.

How to download sas program to excel