I have a problem where I need to read in excel file in to EG. This file excel file has names of organizations and some of names have apostrophe (').
Ex. Kids' Organization Inc.
So I get following warning
WARNING: The quoted string currently being processed has become more than 262 characters long. You may have unbalanced quotation marks.
What version of EGuide and SAS? The method of reading Excel changed from 4.1 to 4.2. Also, are you working with the Excel file in place or converting it to a SAS dataset; those choices also affect how the file is read.
I believe in version 4.2, on the last screen of the wizard there are a couple options about removing problem characters or putting the values into the code itself. You might try one or both of those to see if it resolves the problem. Maybe not... but that's the best I've got right now.