topic Unintended trailing space created in SAS Programming

Unintended trailing space created

hhchenfx — Mon, 15 Feb 2021 03:59:23 GMT

Hi Everyone,

I use the code below to create temporary command and it create a trailing space in the id value.

it should be like

id='F2_w1_w2_N_3109'; instead of

id='F2_w1_w2_N_3109 ';

The temporary full command is below

IF brk25_roc94 =0 then do; id='F2_w1_w2_N_3109 '; output;end;
IF brk25_roc94 =0 then do; id='F2_w1_w2_N_3107 '; output;end;

Is there any way to avoid that space?

Thank you for your help.

HHCFX

filename tmp temp;
data null;
set setupid_check end=last_cond;
file tmp;
put 'IF ' a_name '=' a_value  ' then do; id=' "'" id "'"	'; output;end;' ;
options source2;run;

Re: Unintended trailing space created

Astounding — Mon, 15 Feb 2021 04:40:39 GMT

On the one hand, it's difficult to imagine how a trailing space will hurt anything. If the length of ID is set anyplace in the code, that length will be in effect whether there is a trailing space or not. However, you can get rid of it if needed by changing this line:

put 'IF ' a_name '=' a_value  ' then do; id=' "'" id "'"	';

To remove the trailing space, back up and write over it:

put 'IF ' a_name '=' a_value  ' then do; id=' "'" id +(-1) "'"	';

Re: Unintended trailing space created

qoit — Mon, 15 Feb 2021 05:35:02 GMT

Another method if the trailing increases by 1,2 or unknown spaces:

data setupid_check;
	a_name = 'brk25_roc94';
	id = 'F2_w1_w2_N_3107';
	a_value = 0;
run;

data null;
	set setupid_check (rename=(id = id_)) end=last_cond;
	id = cats("'",id_,"'");
	file print;
	put 'IF ' a_name '=' a_value  ' then do; id=' id	'; output;end;';
	options source2;
run;

Re: Unintended trailing space created

Ksharp — Mon, 15 Feb 2021 11:39:20 GMT

put 'IF ' a_name '=' a_value ' then do; id=' "'" id +(-1) "'" '; output;end;' ;

Re: Unintended trailing space created

hhchenfx — Mon, 15 Feb 2021 19:12:58 GMT

Thank you everyone for helping.

HHCFX