topic Checking Column based on format in SAS Procedures

Checking Column based on format

deleted_user — Thu, 09 Apr 2009 21:27:00 GMT

I'm very new to SAS
Please excuse my ignorance with some of my questions.
I have a social security column which is manually entered by some outside users.
Is there a way for me to check this column based on this format: XXX-XX-XXXX
I want to find the columns that don't match this format if possible.

Thank You
Jerry

Re: Checking Column based on format

sbb — Thu, 09 Apr 2009 22:12:21 GMT

One technique in a SAS DATA step is to use TRANSLATE such as:

DATA _NULL_;
SSN = '222-22-2222';
IF TRANSLATE(SSN,'%%%%%%%%%%','0123456789') NE '%%%-%%-%%%%' THEN PUTLOG '>ERROR> INVALID VARIABLE: ' SSN= ;
RUN;

Scott Barry
SBBWorks, Inc.

Re: Checking Column based on format

deleted_user — Fri, 10 Apr 2009 12:41:22 GMT

Scott,
Thank you again for your help. That is what I was looking for. All I have to is change it around a bit for populate the column with null if the format doesn't match.

Thank You
Jerry

Re: Checking Column based on format

deleted_user — Fri, 10 Apr 2009 12:48:45 GMT

Regular expressions would do this too.

A right riveting read...

http://www2.sas.com/proceedings/sugi29/265-29.pdf