topic Flag column having special character except dot, apostrophe, hyphen and comma in SAS Programming

Flag column having special character except dot, apostrophe, hyphen and comma

DeepakSwain — Mon, 15 Oct 2018 14:31:48 GMT

Hi there,

I need your kind help to detect one column having any special characters with or without dot, apostrophe, hyphen and comma. If it contains only dot, apostrophe, hyphen or comma, I don't want to flag.

data have;
input  name $;
datalines;
abc
def_
def-ghi
def's
def.
def@ghi.ijk
def-ghi&ijk
def%
;
run;

I want to flag the following:

def_

def@ghi.ijk
def-ghi&ijk
def%

Thank you in advance for your kind reply.

Regards,

Re: Flag column having special character except dot, apostrophe, hyphen and comma

ballardw — Mon, 15 Oct 2018 14:52:55 GMT

You may want to provide an explicit definition of "special characters". I don't believe that there is an actual standard definition. I know I have issues with various password rules and they have different lists of special characters that are acceptable or refused.

This might get you started. It should be easy to add or remove suspect characters though a " as done will be a bit trickier.

data have;
input  name $;
flag = findc(name,"!@#$%^&*()_+=",'')>0;
datalines;
abc
def_
def-ghi
def's
def.
def@ghi.ijk
def-ghi&ijk
def%
;
run;

Re: Flag column having special character except dot, apostrophe, hyphen and comma

DeepakSwain — Mon, 15 Oct 2018 15:03:20 GMT

Hi Ballardw,

The suggested advice is great. Only limitation with this to provide a list of special characters of interest to flag.

I am trying to use ANYPUNCT function but unable to apply my exclusion list i.e. dot, aposytrophe, hypen and comma.

Can you kindly help me if feasible to use anypunct function so the code may be generalized.

Once again thank you for your kind reply.

Regards,

Re: Flag column having special character except dot, apostrophe, hyphen and comma

ballardw — Mon, 15 Oct 2018 15:13:53 GMT

ANYPUNCT will not work as several of the characters you appear to want flagged such a & and @ (note: asked for definition of "special character" ) are not punctuation characters.

Re: Flag column having special character except dot, apostrophe, hyphen and comma

Tom — Mon, 15 Oct 2018 17:58:59 GMT

What is your definition of special? All of the strings you posted have characters other than the ones you listed. Did you mean to allow normal alphanumeric characters?

data want ;
   set have;
   flag=' '^=compress(name,".',-",'ad');
run;
proc print;
run;

Obs    name           flag

 1     abc              0
 2     def_             1
 3     def-ghi          0
 4     def's            0
 5     def.             0
 6     def@ghi.ijk      1
 7     def-ghi&ijk      1
 8     def%             1