To specify which sheet SAS should import use the sheet="sheetname" statement. The default is for SAS to read the first sheet. Note that sheet names can only be 31 characters long. The getnames=yes is the default setting and SAS will automatically use the first row of data as variable names. If the first row of your sheet does not contain ...

Jan 17, 2014 · Subject: How to best import multiple sheets from an excel spreadsheet Hi I have an excel spreadsheet that has multiple tabs/sheets in the file. I would like to be able to import all or most of these tabs into my access database at one time.