topic Re: Perl Regular Expression PRXPARSE in SAS Programming https://communities.sas.com/t5/SAS-Programming/Perl-Regular-Expression-PRXPARSE/m-p/351242#M81749 <P>Thank you, what would the syntax be for PRXMatch?</P> Wed, 19 Apr 2017 12:13:48 GMT IgawaKei29 2017-04-19T12:13:48Z Perl Regular Expression PRXPARSE https://communities.sas.com/t5/SAS-Programming/Perl-Regular-Expression-PRXPARSE/m-p/351230#M81744 <P>So I am trying to understand how best to do this using Perl. &nbsp;I have some sample data which I want to read in as a data step.</P> <P>&nbsp;</P> <P>So&nbsp;</P> <P>&nbsp;</P> <PRE>Data work.test; set work.PerlData; run;</PRE> <P>However I want to use the following</P> <PRE>prxparse('/spa/');</PRE> <P>I am just not sure how to use this Perl script to show me all hotel names with Spa within it.</P> <P>&nbsp;</P> <P>Excel file looks like: (all fictious data) Just trying to understand Perl before I try it with real data.</P> <P>&nbsp;</P> <TABLE width="1043"> <TBODY> <TR> <TD width="199">Hotel_Name</TD> <TD width="248">Company</TD> <TD width="96">Phone</TD> <TD width="133">Manager</TD> <TD width="367">Email</TD> </TR> <TR> <TD>Ivory Courtyard Resort</TD> <TD>Ac Metus Vitae LLC</TD> <TD>(140) 462-6599</TD> <TD>Felicia Hutchinson</TD> <TD>blandit.Nam.nulla@commodoauctor.edu</TD> </TR> <TR> <TD>Sunrise Mirror Resort</TD> <TD>Quisque Tincidunt Company</TD> <TD>(544) 574-0753</TD> <TD>Hollee Clayton</TD> <TD>lacinia.at@interdumlibero.edu</TD> </TR> <TR> <TD>Crimson Shore Hotel</TD> <TD>Et Netus Et Consulting</TD> <TD>(931) 720-2951</TD> <TD>Pascale Bell</TD> <TD>sapien@vulputate.co.uk</TD> </TR> <TR> <TD>Pleasant Circus Resort &amp; Spa</TD> <TD>Ut Sem LLP</TD> <TD>(262) 723-5866</TD> <TD>Leonard Middleton</TD> <TD>elementum.at.egestas@infelisNulla.com</TD> </TR> <TR> <TD>Lord's Plains Hotel</TD> <TD>Et Netus Corporation</TD> <TD>(673) 576-3366</TD> <TD>Zeus Chan</TD> <TD>sagittis.felis.Donec@lobortistellus.edu</TD> </TR> <TR> <TD>Noble Refuge Hotel</TD> <TD>Donec Corporation</TD> <TD>(110) 924-8302</TD> <TD>Leilani Shelton</TD> <TD>rhoncus@interdum.com</TD> </TR> <TR> <TD>Revelation Hotel &amp; Spa</TD> <TD>Aliquam Tincidunt Nunc Corp.</TD> <TD>(559) 588-0513</TD> <TD>Armand Bishop</TD> <TD>eros.Nam.consequat@Aliquameratvolutpat.org</TD> </TR> <TR> <TD>Countryside Hotel</TD> <TD>Purus Company</TD> <TD>(241) 761-4967</TD> <TD>Seth Slater</TD> <TD>Duis.elementum.dui@eu.net</TD> </TR> <TR> <TD>Panorama Hotel &amp; Spa</TD> <TD>Adipiscing Incorporated</TD> <TD>(113) 803-4658</TD> <TD>Tamekah Conrad</TD> <TD>ligula.Donec@Nunccommodo.com</TD> </TR> <TR> <TD>Stellar Hotel &amp; Spa</TD> <TD>Magnis Dis Parturient Associates</TD> <TD>(515) 575-5373</TD> <TD>Forrest Haley</TD> <TD>eu.elit.Nulla@ultriciesdignissimlacus.com</TD> </TR> <TR> <TD>Northern Obelisk Hotel</TD> <TD>Nec Associates</TD> <TD>(320) 680-9409</TD> <TD>Kim Malone</TD> <TD>cursus.et@ametmetusAliquam.ca</TD> </TR> <TR> <TD>Western Thicket Resort &amp; Spa</TD> <TD>Felis Orci Adipiscing Corporation</TD> <TD>(713) 874-6161</TD> <TD>Wang Melendez</TD> <TD>leo.in@Uttinciduntorci.net</TD> </TR> <TR> <TD>Noble Heritage Hotel</TD> <TD>Nostra Per LLC</TD> <TD>(918) 899-8305</TD> <TD>Ira Thompson</TD> <TD>Sed@Proinsed.edu</TD> </TR> <TR> <TD>Ruby Mansion Resort</TD> <TD>Eu Dui Associates</TD> <TD>(110) 805-0328</TD> <TD>Tobias Britt</TD> <TD>enim@orcitincidunt.edu</TD> </TR> </TBODY> </TABLE> Wed, 19 Apr 2017 11:27:41 GMT https://communities.sas.com/t5/SAS-Programming/Perl-Regular-Expression-PRXPARSE/m-p/351230#M81744 IgawaKei29 2017-04-19T11:27:41Z Re: Perl Regular Expression PRXPARSE https://communities.sas.com/t5/SAS-Programming/Perl-Regular-Expression-PRXPARSE/m-p/351240#M81748 <P>The function prxparse checks the syntax of a regular expression, it does not check wether a something matches the expression. You need to use prxmatch for that.</P> Wed, 19 Apr 2017 12:08:18 GMT https://communities.sas.com/t5/SAS-Programming/Perl-Regular-Expression-PRXPARSE/m-p/351240#M81748 andreas_lds 2017-04-19T12:08:18Z Re: Perl Regular Expression PRXPARSE https://communities.sas.com/t5/SAS-Programming/Perl-Regular-Expression-PRXPARSE/m-p/351242#M81749 <P>Thank you, what would the syntax be for PRXMatch?</P> Wed, 19 Apr 2017 12:13:48 GMT https://communities.sas.com/t5/SAS-Programming/Perl-Regular-Expression-PRXPARSE/m-p/351242#M81749 IgawaKei29 2017-04-19T12:13:48Z Re: Perl Regular Expression PRXPARSE https://communities.sas.com/t5/SAS-Programming/Perl-Regular-Expression-PRXPARSE/m-p/351248#M81752 <PRE> if prxmatch('/\bspa\b/i',hotel_name) then output; </PRE> Wed, 19 Apr 2017 12:20:39 GMT https://communities.sas.com/t5/SAS-Programming/Perl-Regular-Expression-PRXPARSE/m-p/351248#M81752 Ksharp 2017-04-19T12:20:39Z Re: Perl Regular Expression PRXPARSE https://communities.sas.com/t5/SAS-Programming/Perl-Regular-Expression-PRXPARSE/m-p/351250#M81754 <P>Thank you! &nbsp;Just starting to get my head wrapped around the syntax</P> Wed, 19 Apr 2017 12:24:03 GMT https://communities.sas.com/t5/SAS-Programming/Perl-Regular-Expression-PRXPARSE/m-p/351250#M81754 IgawaKei29 2017-04-19T12:24:03Z