Subsetting where statement with blank space producing unexpected results

SAShole — Tue, 04 May 2021 18:51:50 GMT

Can someone explain why this:

data have;
	set sashelp.class;
	where name='Alice';
run;

gives the same results as this (space after Alice)?

data have;
	set sashelp.class;
	where name='Alice ';
run;

I would think the blank space would cause SAS to not evaluate it as equivalent.

Re: Subsetting where statement with blank space producing unexpected results

Tom — Tue, 04 May 2021 18:54:41 GMT

SAS stores character strings as fixed length padded with spaces.

So when it compares two strings it ignores the trailing spaces.

Re: Subsetting where statement with blank space producing unexpected results

Reeza — Tue, 04 May 2021 18:58:33 GMT

Since trailing blanks are ignored in a comparison, 'fox ' is equivalent to 'fox'. However, because blanks at the beginning and in the middle of a character value are significant to SAS, ' fox' is not equivalent to 'fox'.

https://documentation.sas.com/doc/en/lrcon/9.4/p00iah2thp63bmn1lt20esag14lh.htm#p1vu0ts68u42xun141p7vt4ne29k

Character Comparisons

You can perform comparisons on character operands, but the comparison always yields a numeric result (1 or 0). Character operands are compared character by character from left to right. Character order depends on the collating sequence, usually ASCII or EBCDIC, used by your computer.

For example, in the EBCDIC and , G is greater than A. Therefore, this expression is true:

'Gray'>'Adams'

Two- of unequal length are compared as if blanks were attached to the end of the shorter value before the comparison is made. A blank, or missing character value, is smaller than any other printable character value. For example, because . is less than h, this expression is true:

'C. Jones'<'Charles Jones'

You can compare only a specified prefix of a character expression by using a colon (:) after the comparison operator. SAS truncates the longer value to the length of the shorter value during the comparison. In the following example, the colon modifier after the equal sign tells SAS to look at only the first character of values of the variable LastName and to select the observations with names beginning with the letter S:

if lastname=:'S';

Because printable characters are greater than blanks, both of the following statements select observations with values of LastName that are greater than or equal to the letter S:

if lastname>='S';
if lastname>=:'S';

Note: If you compare a zero-length character value with any other character value in either an IN: comparison or an EQ: comparison, the two-character values are not considered equal. The result always evaluates to 0, or false.

The operations that are discussed in this section show you how to compare entire character strings and the beginnings of character strings. Several SAS enable you to search for and extract values from within character strings. See SAS Functions and CALL Routines: Reference for complete descriptions of all SAS functions.

Re: Subsetting where statement with blank space producing unexpected results

SAShole — Tue, 04 May 2021 19:35:28 GMT

Thank you for the detailed response Reeza, very helpful!

topic Re: Subsetting where statement with blank space producing unexpected results in SAS Programming

Subsetting where statement with blank space producing unexpected results

Re: Subsetting where statement with blank space producing unexpected results

Re: Subsetting where statement with blank space producing unexpected results

Character Comparisons

Re: Subsetting where statement with blank space producing unexpected results