topic Re: Prxmatch function : first postion in SAS Programming

Prxmatch function : first postion

SASdevAnneMarie — Mon, 22 May 2023 15:23:54 GMT

Hello Experts,

My data in column CODE_P is :

Z56

Z98

JK.

I would like to have only the data with Z. How to write this condition with Prxmatch function please (to hold all data starting with Z) ?

My actual code is :

	if prxmatch("m/Z/oi",CODE_P)>0 then do;

This code works well, but I would like to add the condition "on first position". Thank you !

FreelanceReinh — Mon, 22 May 2023 15:45:26 GMT

Insert the "^" sign before the "Z":

if prxmatch("m/^Z/oi",CODE_P)>0 then do;

But for a simple criterion like this I would rather avoid the slow PRX functions and use something like

if upcase(code_p)=:'Z' then do;

SASdevAnneMarie — Tue, 23 May 2023 15:16:57 GMT

Thank you! That works!