Excellent.  Glad it worked.   Jim   ... View more

RW9 you are missing the point of my question, Jim has already answered it. Has nothing to do with my code, which was only typed to illustrate the written explanation as a visual. ... View more

Ah.  I see what you're saying.  I didn't pay attention to the way in which the macro was being invoked.  Hmm.  Yeah, that doesn't seem quite right...  I'll have to play with that a bit more on my 9.4 at home this evening if I get a chance.   Jim ... View more

PascalMaurice:   I'm at work now.  Here (below) is a cut and paste from a functioning program.  This may be helpful in terms of the syntax which can be a bit tricky.  The syntax I included above isn't quite right.  Better to use this actual working code as an example.  This code reads through a list of tabs (worksheets) exported as text from two different Excel workbooks, importing each tab in turn (163 of them for each Excel file) into SAS.  It compares each of the two sets tabs, a 100% sample vs. a 1% sample of data, looking for significant differences in the distribution of values and writes a report.   DATA _NULL_; SET WORK.Tab_Names; CALL EXECUTE ('%NRSTR(%Process_Excel_Tab(Tab_Name=' || strip(TabName) || ');)'); RUN; %Check_SYSERR;   Inside the macro, I set up a number of parameters based on the name of the Tab that is passed into the macro.  These parameters then control a variety of programs that process data based on the parameters.   %MACRO Process_Excel_Tab(Tab_Name=); %LET DeBug = *; %LET Data_Type = 100; %LET FileIn = &DataLib&Tab_Name._&Data_Type; %LET Data_Format = txt; %LET Report_Title = &Tab_Name._&Data_Type; OPTIONS SOURCE2; %INCLUDE "&IncLib.Import_Program.sas"; OPTIONS NOSOURCE2; %*Check_SYSERR; TITLE "&Report_Title"; PROC CONTENTS DATA=Out.Percent_&Data_Type POSITION; RUN &Control_Value; %Check_SYSERR; PROC PRINT DATA=Out.Percent_&Data_Type; RUN &Control_Value; %Check_SYSERR; /*--------------------------------------------------------------------------*/ %LET DeBug = *; %LET Data_Type = 1; %LET FileIn = &DataLib&Tab_Name._&Data_Type; %LET Data_Format = txt; %LET Report_Title = &Tab_Name._&Data_Type; OPTIONS SOURCE2; %INCLUDE "&IncLib.Import_Program.sas"; OPTIONS NOSOURCE2; %*Check_SYSERR; TITLE "&Report_Title"; PROC CONTENTS DATA=Out.Percent_&Data_Type POSITION; RUN &Control_Value; %Check_SYSERR; PROC PRINT DATA=Out.Percent_&Data_Type; RUN &Control_Value; %Check_SYSERR; /*--------------------------------------------------------------------------*/ %LET DeBug = *; %LET Data_Type1 = 1; %LET Data_Type100 = 100; %LET HTMLout = &HTMLlib&Tab_Name._&Data_Type1._Percent_vs_&Data_Type100..html; OPTIONS SOURCE2; %INCLUDE "&IncLib.Compare_Program.sas"; OPTIONS NOSOURCE2; %*Check_SYSERR; /*--------------------------------------------------------------------------*/ TITLE "&Tab_Name. -- &Data_Type1. Percent vs. &Data_Type100. Percent"; PROC CONTENTS DATA=Out.Percent_&Data_Type100._Final POSITION; RUN &Control_Value; %Check_SYSERR; ODS HTML BODY="&HTMLout"; PROC PRINT DATA=Out.Percent_&Data_Type100._Final; ID Range_Start Range_End ; RUN &Control_Value; %Check_SYSERR; ODS HTML CLOSE; PROC DELETE DATA=Out.Percent_&Data_Type1; RUN &Control_Value; %Check_SYSERR; PROC DELETE DATA=Out.Percent_&Data_Type100; RUN &Control_Value; %Check_SYSERR; PROC DELETE DATA=Out.Percent_&Data_Type100._Final; RUN &Control_Value; %Check_SYSERR; %MEND Process_Excel_Tab; I wrote this code in a hurry in one night, so it's not the most elegant, but perhaps this may be helpful as something of an example how to work with macro variables while processing tabs exported as text from Excel.  I apologize if you already know all of this.     Jim ... View more

Chris,   No hurry.  The workaround takes care of business for now, and I don't forsee any situations that might require me to have a true solution.   I'm going to go ahead and mark my work around as the "solution" so as to resolve this thread.  If a fix comes out, perhaps a brief note to that effect on SAS Dummy would be in order.   Thanks,   Jim ... View more

In the above post, the :S (frustrated smiley) is actually a : followed by an S with no spaces in between.   Jim ... View more