topic Re: how to find unexpected characters in a string in SAS Programming https://communities.sas.com/t5/SAS-Programming/how-to-find-unexpected-characters-in-a-string/m-p/853437#M337320 <P>Suggest looking into the VERIFY() function.</P> Thu, 12 Jan 2023 12:59:36 GMT Quentin 2023-01-12T12:59:36Z how to find unexpected characters in a string https://communities.sas.com/t5/SAS-Programming/how-to-find-unexpected-characters-in-a-string/m-p/853419#M337311 <P>I have one dataset/dummy data .</P> <P>for example:</P> <P>data test ;</P> <P>length text $ 20 ;</P> <P>text='i love you' ;</P> <P>output;</P> <P>text='i like you' ;</P> <P>output ;</P> <P>run;</P> <P>&nbsp;</P> <P>my question is how to find unexcepted values in text variable ?</P> <P>&nbsp;</P> Thu, 12 Jan 2023 11:30:51 GMT https://communities.sas.com/t5/SAS-Programming/how-to-find-unexpected-characters-in-a-string/m-p/853419#M337311 thanikondharish 2023-01-12T11:30:51Z Re: how to find unexpected characters in a string https://communities.sas.com/t5/SAS-Programming/how-to-find-unexpected-characters-in-a-string/m-p/853421#M337313 <P>Define 'unexpected' ?</P> Thu, 12 Jan 2023 11:31:52 GMT https://communities.sas.com/t5/SAS-Programming/how-to-find-unexpected-characters-in-a-string/m-p/853421#M337313 PeterClemmensen 2023-01-12T11:31:52Z Re: how to find unexpected characters in a string https://communities.sas.com/t5/SAS-Programming/how-to-find-unexpected-characters-in-a-string/m-p/853422#M337314 I have copied some text from Excel and pasted into sas Thu, 12 Jan 2023 11:33:04 GMT https://communities.sas.com/t5/SAS-Programming/how-to-find-unexpected-characters-in-a-string/m-p/853422#M337314 thanikondharish 2023-01-12T11:33:04Z Re: how to find unexpected characters in a string https://communities.sas.com/t5/SAS-Programming/how-to-find-unexpected-characters-in-a-string/m-p/853428#M337317 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/209685">@thanikondharish</a>&nbsp;wrote:<BR />I have copied some text from Excel and pasted into sas<HR /></BLOCKQUOTE> <P>Please define "unexpected".</P> Thu, 12 Jan 2023 11:40:24 GMT https://communities.sas.com/t5/SAS-Programming/how-to-find-unexpected-characters-in-a-string/m-p/853428#M337317 andreas_lds 2023-01-12T11:40:24Z Re: how to find unexpected characters in a string https://communities.sas.com/t5/SAS-Programming/how-to-find-unexpected-characters-in-a-string/m-p/853437#M337320 <P>Suggest looking into the VERIFY() function.</P> Thu, 12 Jan 2023 12:59:36 GMT https://communities.sas.com/t5/SAS-Programming/how-to-find-unexpected-characters-in-a-string/m-p/853437#M337320 Quentin 2023-01-12T12:59:36Z