Microsoft Excel importing data from

The interactive SAS Import Wizard provides an easy way to import the contents of Microsoft Excel and Access files into SAS. Here again, the Import Wizard is essentially a graphical user interface that builds the PROC IMPORT code for you. Begin in the interactive SAS windowing environment by selecting File from the toolbar and then Import Data... from the drop-down menu. A window like the following will appear, where you can select Microsoft Excel as a standard data source. 

Because Microsoft Office is so widely used, it is sometimes necessary for you to import data directly from Microsoft Excel or Microsoft Access. Excel files make for a poor database, however. First, Excel files are almost guaranteed to come from a system that is not compliant with CFR 21 - Part 11. Second, it is often the case that the Excel files were created in such a way that the data are not WYSIWYG ( what you see is what you get ). In other words, each cell in Excel could be entered with a different Excel format, which you would not see until you either reformat an entire column in Excel or try to have some other software like SAS read the contents of the Excel file. For these reasons, it is best not to accept Microsoft Excel data as a data source for clinical trials if at all possible. 

Data can be imported (or linked) from Microsoft Excel in two ways. 

The way to import a Microsoft Excel spreadsheet into MATLAB environment (i.e., Workspace) is explained in detail in Sec. 5.2. Here, the data will be brought to the MATLAB environment via creating a dataset from an Excel spreadsheet. 

Step 5. After the simulation, you can find the report file in the CAOutput directory. At this point you may wish to rename the output file so that you can relate it to the specific settings employed. You may also wish to remove this file from the CAOutput subdirectory so that this directory does not become too crowded. If you wish to perform a statistical analysis of the simulation data, you can import the data into an appropriate statistical analysis program, such as Microsoft s EXCEL ... 

---