https://communities.sas.com/t5/SAS-Programming/how-to-capture-character-variable-data-containing-space/m-p/407241#M99217 <P>Why do you want to have 226 included? There's no blank at the beginning or in the middle, only at the end.</P> <P>Checking a SAS character variable for trailing blanks makes no sense, as _all_ SAS character variables have trailing blanks (unless they're completely filled). "Empty" character variables contain blanks.</P> <P>&nbsp;</P> <P>To find the others, you might want to check</P> <PRE><CODE class=" language-sas">if indexc(trim(countryname),' ') &gt; 0;</CODE></PRE> <P>&nbsp;</P> Wed, 25 Oct 2017 13:07:13 GMT Kurt_Bremser 2017-10-25T13:07:13Z https://communities.sas.com/t5/SAS-Programming/how-to-capture-character-variable-data-containing-space/m-p/407229#M99215 <P>Hi,</P> <P>In the attached sheet, I want to read the data into SAS environment and then find all country id with extra space in the beginning or middle.</P> <P>&nbsp;</P> <P>How to proceed. My output would be country id 222, 223 and 226</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 25 Oct 2017 12:48:15 GMT https://communities.sas.com/t5/SAS-Programming/how-to-capture-character-variable-data-containing-space/m-p/407229#M99215 Abraham 2017-10-25T12:48:15Z https://communities.sas.com/t5/SAS-Programming/how-to-capture-character-variable-data-containing-space/m-p/407241#M99217 <P>Why do you want to have 226 included? There's no blank at the beginning or in the middle, only at the end.</P> <P>Checking a SAS character variable for trailing blanks makes no sense, as _all_ SAS character variables have trailing blanks (unless they're completely filled). "Empty" character variables contain blanks.</P> <P>&nbsp;</P> <P>To find the others, you might want to check</P> <PRE><CODE class=" language-sas">if indexc(trim(countryname),' ') &gt; 0;</CODE></PRE> <P>&nbsp;</P> Wed, 25 Oct 2017 13:07:13 GMT https://communities.sas.com/t5/SAS-Programming/how-to-capture-character-variable-data-containing-space/m-p/407241#M99217 Kurt_Bremser 2017-10-25T13:07:13Z