Hi All I have a list of names that i am trying to add in a macro variable as follows- %let EXCLUDE = ('Randomgroup Fl's dummy' , 'Randomgroup &GA' , 'Randomgroup KY' , 'Randomgroup NJ' , 'Randomgroup NM') ; Later on in want to use it in my program as proc sql; create table exclusion_data as select distinct * from Base_data where group_name in &exclude. ; quit; Now since one of the name in the list (Randomgroup Fl's dummy) has a single quote my program errors out with below error- The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. Could you please help with how do i deal with it. P.S.- I tried to enclose my vales with a double quote while inserting in the macro variable still got the same error. Thanks Bhawna
... View more
