Hello, I have to import 30+ excel workbooks into SAS for analysis. Each workbook has the same number of tabs with the same format. There are 12 tabs per workbook, with the first tab being INSTRUCTIONS. I need to import tabs 2-12 of each workbook. Here is my attempt at a macro: ************************************************* %macro pim(sheet); Proc Import Out=test Datafile='/home/risk/Consumer Heatmap 2015.xls' DBMS=xls Replace; Sheet= '&sheet'; Datarow=10; Run; %mend pim; %pim(Heat Map Channel Agnostic); %pim(ATM); ************************************************ When I run the above macro, I get this error. Note the two // before the word Consumer. I have triple checked and retyped the file path to eliminate an possible space but still get the same error. OTE: Writing RTF Body file: EGRTF 30 FILENAME EGSR TEMP; 31 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 32 STYLE=HtmlBlue 33 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/6.1/Styles/HtmlBlue.css") 34 NOGTITLE 35 NOGFOOTNOTE 36 GPATH=&sasworklocation 37 ENCODING=UTF8 38 options(rolap="on") 39 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 40 41 GOPTIONS ACCESSIBLE; 42 %pim('Heat Map Channel Agnostic'); Requested Sheet Name not found on Excel -> /home/risk//Consumer Heatmap 2015.xls Requested Input File Is Invalid ERROR: Import unsuccessful. See SAS Log for details. Few questions: 1. Any idea on why SAS sees two // instead of one? 2. Since I am importing multiple sheets, when using proc import, is it possible: a. have the multiple sheets imported as one dataset per workbook? For example, workbook1 will have all its sheet in dataset1, workbook2 will be in dataset2, etc? b. to add a column to indicate the channel (i.e. Agnostic, ATM, etc)? Or do I have to do this as another datastep?
... View more