topic select customized data format in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/select-customized-data-format/m-p/106757#M29745 <HTML><HEAD></HEAD><BODY><P>Hi, this is probably so easy for some.. But How can I select a field only if is in the format like alpha/numeric/alpha eg. M2H or G8R etc.. if I have GG5 or 4 or 66R .. etc. or anything else like this, I don't want it.. <BR />Thanks in advance</P></BODY></HTML> Fri, 09 Aug 2013 18:07:22 GMT podarum 2013-08-09T18:07:22Z select customized data format https://communities.sas.com/t5/SAS-Procedures/select-customized-data-format/m-p/106757#M29745 <HTML><HEAD></HEAD><BODY><P>Hi, this is probably so easy for some.. But How can I select a field only if is in the format like alpha/numeric/alpha eg. M2H or G8R etc.. if I have GG5 or 4 or 66R .. etc. or anything else like this, I don't want it.. <BR />Thanks in advance</P></BODY></HTML> Fri, 09 Aug 2013 18:07:22 GMT https://communities.sas.com/t5/SAS-Procedures/select-customized-data-format/m-p/106757#M29745 podarum 2013-08-09T18:07:22Z Re: select customized data format https://communities.sas.com/t5/SAS-Procedures/select-customized-data-format/m-p/106758#M29746 <HTML><HEAD></HEAD><BODY><P>data have;</P><P> input var $;</P><P> cards;</P><P> M2H</P><P> G8R</P><P> GG5</P><P> 66R</P><P> ;</P><P></P><P> DATA WANT;</P><P>&nbsp; SET HAVE;</P><P>&nbsp; IF PRXMATCH('/[a-zA-Z]\d[a-zA-Z]/',var) &gt;0;</P><P>run;</P><P></P><P>Haikuo </P></BODY></HTML> Fri, 09 Aug 2013 18:25:28 GMT https://communities.sas.com/t5/SAS-Procedures/select-customized-data-format/m-p/106758#M29746 Haikuo 2013-08-09T18:25:28Z Re: select customized data format https://communities.sas.com/t5/SAS-Procedures/select-customized-data-format/m-p/106759#M29747 <HTML><HEAD></HEAD><BODY><P>thank you</P><P><BR /> </P></BODY></HTML> Fri, 09 Aug 2013 18:36:37 GMT https://communities.sas.com/t5/SAS-Procedures/select-customized-data-format/m-p/106759#M29747 podarum 2013-08-09T18:36:37Z