I have an email string with a list of email addresses. each email address is surrounded by single quotes. i want to write a program that will remove or add an email address with the quotes around it.   For example 'donald.duck@cartoon.com' I can search the string for the email to remove using compress but I cannot remove the single quotes around it because other email's have the quotes. Any suggestions on how to get rid of the quotes once the email is gone or both at once?   before code  example string: ('donald.duck@cartoon.com' 'becky.green@grass.com' 'mark.tomas@lbschool.net') after process  example string: ('' 'becky.green@grass.com' 'mark.tomas@lbschool.net')   ... View more

I want to read these two macro into the proc sql. I keep getting an error that a select statement is missing; I put a smaple dataset at the below to use %LET ZIPCODE_LIST2=('95201','95202','95203','95204','95205','95206','95207','95208','95209','95210','95211','95212','95213','95214','95215','95219', '95267','95269','95296','95297'); %let yrmo_b2=202208;   proc sql; CREATE TABLE attrib2 AS seLECT *, case index when '211A' then '212A' when '211B' then '212B' when '211C' then '212C' when '211D' then '212D' when '211E' then '212E' else index2 end FROM attrib1 WHERE zipcode IN (&ZIPCODE_LIST2) and yrmo  in ( 202207 ,&yrmo_b2); quit;   DATA ACO1; input ID $ INDEX $ YRMO zipcode $; DATALINES; 10528076 211D 202207 95204 10588202 211E 202207 95212 10590191 211B 201802 95336 10593162 211D 202208 95219 10593777 211D 202204 95201 10593787 211D 201802 95336 10594270 211C 201802 95376 10594273 211C 202208 95214 10595143 211D 201802 95336 10596446 211E 202208 95336 10597124 211D 202207 95201 10597867 211D 202206 95376 10598211 211A 202201 95249 10600934 211D 201802 95202 10600935 211D 202205 95336 10601192 211D 202205 95213 10689802 211A 201802 95204 10702706 211C 202208 95204 10735256 211E 202207 95201 10750858 211D 202208 95210 RUN;   ... View more