Programming Resources

Import Excel worksheets with spaces in sheet name into SAS

If importing a sheet within an Excel Workbook, and the sheet has spaces in the name then the normal sheet="sheet with spaces" will not work.

If importing a sheet within an Excel Workbook, and the sheet has spaces in the name then the normal sheet="sheet with spaces" will not work. In this circumstance you need to add a '$' symbol to the end of the sheet name and enclose the sheet name in single quotes within double quotes.

An example is shown below:

proc import out=data1
datafile = "c:\my_data_folder\my_spreadsheet.xls"
dbms=excel
replace;
sheet="'sheet with spaces$'";
getnames = yes;
run;

Recommended SAS log analyser for SAS users:

Take a look at Elvis SAS log analyser. It takes a SAS log, either from the clipboard or from a saved file, and allows you to view it, navigate around it, search it and more. This makes working with large SAS logs much, much easier and faster than simply looking at the log in a non-specialised viewer such as a plain text editor, Internet Explorer or Notepad.

If you are looking for property in Piemonte Italy then we recommend alba property and piedmont property. Italian real estate.