Easy Data Movement between SAS and Microsoft Excel - Exchanging Data Between SAS and Microsoft Excel - page 18

Figure 1.4.8: The “Connect to MS Excel” Options Screen May Appear in a 32/64 Bit Mixed
Environment.
To get an accurate assessment of the software installed on your computer, contact your IT department or
SAS Technical Support.
1.5 Chapter Summary
The examples in this chapter demonstrated how to move data between SAS datasets and Excel worksheets
using the following methods.
● Cut or copy then paste
● Convert text data to Excel column data
● Copy Excel data into a SAS Enhanced Editor window
● Save multiple lines of text into a single Excel cell
● Convert Excel tables to text
● The Export wizard from the SAS Explorer window
● Copy contents to the Windows clipboard
● Save SAS data as HTML
● View a SAS file in Excel
● SAS Export wizard from the File toolbar tab
• SAS Import wizard from the File toolbar tab
We also touched upon some cautions about using SAS to read or write data to Excel when running your
programs in a 32/64-bit mixed environment. These are introductory methods of moving data between the
two systems. In the rest of the topic, I will use and expand on these and other methods that these two
powerful software tools use to transfer data and communicate with one another.