topic how toinclude " and ' in" " in SAS Programming

how toinclude " and ' in" "

Alexxxxxxx — Tue, 16 Apr 2019 15:40:10 GMT

Dear all,

How can I put ' and " among ' ' in the following code?

%MACRO CompnayNameM(no=,Company_name=);

	Data DATASTREAM3_1&no.;
		Set Step9.Datastream_TOTAL_Step3_1;
		if findc(&COMPANY_NAME._Step23, '-’”'"#*@!?/&():;,. 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ','K')>0;
		keep &COMPANY_NAME. &COMPANY_NAME._Step23;
	run;

%MEND CompnayNameM;
%CompnayNameM(no=1,Company_name=NAME)
%CompnayNameM(no=2,Company_name=COMPANY_NAME)
run;

Could you please give me some suggestions? thanks in advance.

Re: how toinclude " and ' in" "

Astounding — Tue, 16 Apr 2019 15:55:09 GMT

There's a general principle involved. When using single quotes to denote a string, refer to a single quote inside the string as two consecutive single quotes. For example:

'A''B'

refers to the same string as:

"A'B"

Re: how toinclude " and ' in" "

ballardw — Tue, 16 Apr 2019 15:59:05 GMT

@Alexxxxxxx wrote:

Dear all,

How can I put ' and " among ' ' in the following code?

%MACRO CompnayNameM(no=,Company_name=);

	Data DATASTREAM3_1&no.;
		Set Step9.Datastream_TOTAL_Step3_1;
		if findc(&COMPANY_NAME._Step23, '-’”'"#*@!?/&():;,. 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ','K')>0;
		keep &COMPANY_NAME. &COMPANY_NAME._Step23;
	run;

%MEND CompnayNameM;
%CompnayNameM(no=1,Company_name=NAME)
%CompnayNameM(no=2,Company_name=COMPANY_NAME)
run;

Could you please give me some suggestions? thanks in advance.

You might be better off explaining which characters you are actually searching for. You have included in your list things that would appear with the modifiers UDP so the character list is way longer than needed.

Re: how toinclude " and ' in" "

AMSAS — Tue, 16 Apr 2019 16:26:31 GMT

Here's a quick example of how to get both single (') and double (") quotes into a string

data _null_ ;
	string="abc'def""ghi" ;
	put string= ;
	
run ;

Note because I used double quotes for my string, I needed to use 2 sets of double quotes inside the string