topic Re: Hello, everyone! My questions is not that hard, but I can't find the answer, so maybe you can help me. I need to create sql,which will show rows, that in their name column have two similar letters stand one by one. Do you know how should I write it? in SAS Data Science https://communities.sas.com/t5/SAS-Data-Science/Hello-everyone-My-questions-is-not-that-hard-but-I-can-t-find/m-p/144087#M9357 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Sample data and desired output will help the forum to suggest a solution.</P></BODY></HTML> Mon, 27 Oct 2014 21:46:07 GMT stat_sas 2014-10-27T21:46:07Z Hello, everyone! My questions is not that hard, but I can't find the answer, so maybe you can help me. I need to create sql,which will show rows, that in their name column have two similar letters stand one by one. Do you know how should I write it? https://communities.sas.com/t5/SAS-Data-Science/Hello-everyone-My-questions-is-not-that-hard-but-I-can-t-find/m-p/144086#M9356 <HTML><HEAD></HEAD><BODY><P>Hello, everyone! My questions is not that hard, but I can't find the answer, so maybe you can help me. I need to create sql,which will show rows, that in their name column have two similar letters stand one by one. Do you know how should I write it? </P></BODY></HTML> Mon, 27 Oct 2014 21:31:40 GMT https://communities.sas.com/t5/SAS-Data-Science/Hello-everyone-My-questions-is-not-that-hard-but-I-can-t-find/m-p/144086#M9356 dzindos_g 2014-10-27T21:31:40Z Re: Hello, everyone! My questions is not that hard, but I can't find the answer, so maybe you can help me. I need to create sql,which will show rows, that in their name column have two similar letters stand one by one. Do you know how should I write it? https://communities.sas.com/t5/SAS-Data-Science/Hello-everyone-My-questions-is-not-that-hard-but-I-can-t-find/m-p/144087#M9357 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Sample data and desired output will help the forum to suggest a solution.</P></BODY></HTML> Mon, 27 Oct 2014 21:46:07 GMT https://communities.sas.com/t5/SAS-Data-Science/Hello-everyone-My-questions-is-not-that-hard-but-I-can-t-find/m-p/144087#M9357 stat_sas 2014-10-27T21:46:07Z Re: Hello, everyone! My questions is not that hard, but I can't find the answer, so maybe you can help me. I need to create sql,which will show rows, that in their name column have two similar letters stand one by one. Do you know how should I write it? https://communities.sas.com/t5/SAS-Data-Science/Hello-everyone-My-questions-is-not-that-hard-but-I-can-t-find/m-p/144088#M9358 <HTML><HEAD></HEAD><BODY><P>Don't put your question in the title. Consider it the subject line of t an email and the message in the body.</P><P></P><P>Also as stat@sas has suggested sample data and desired output may help.</P><P></P><P>Just guessing, look into Proc Contents and/or SASHELP.VTABLE </P></BODY></HTML> Mon, 27 Oct 2014 21:53:37 GMT https://communities.sas.com/t5/SAS-Data-Science/Hello-everyone-My-questions-is-not-that-hard-but-I-can-t-find/m-p/144088#M9358 Reeza 2014-10-27T21:53:37Z