All the definitions on AZdictionary were written by people just like you. Now's your chance to add your own!
1 In Excel, select â File â and click Save As. 2  Choose â Tools General Options â at the bottom of the window. 3  Select the check-box for â Read-only recommended â, then select â OK 4  â. Select â Save 5  â. If prompted, choose â Yes â to update the file with the read-only setting.f you have a file that is sensitive to changes, you can force Excel 2013 or 2010 to prompt the user to open as Read Only whenever they attempt to open the file. Hereâs how to enable this setting. 1  In Excel, select â File â and click Save As. 2  Choose â Tools General Options â at the bottom of the window.
The example could be read directly by SAS using PROC IMPORT. However, the Excel. spreadsheet could only have one tab, ergo the reason to save as Excel 5.0. The second and. third examples could be read in with data step input statements. The third example was readable. only if you had no missing data in any columns, as SAS assumes variables in sequential rather. than positional order.