SSN QC - SAS Support Communities

Quartz | Level 8

Quartz | Level 8

SSN QC

Posted 10-27-2014 01:39 PM (1234 views)

How to check the validity of SSN. i.e to check if the given SSN has proper length, there are no alpha's, it is not 11111111 etc.

3 REPLIES 3

Barite | Level 11

Barite | Level 11

Re: SSN QC

Posted 10-27-2014 02:20 PM (1168 views) | In reply to SASPhile

can you clarify your self more

give example dataset

Quartz | Level 8

Quartz | Level 8

Re: SSN QC

Posted 10-27-2014 03:40 PM (1168 views) | In reply to mohamed_zaki

There are a bunch of standardized rules for SSN.So I'm looking if there is a macro in place already that does QC on the SSN.

Super User

Super User

Re: SSN QC

Posted 10-27-2014 04:08 PM (1168 views) | In reply to SASPhile

I found one by googling:

http://www.lexjansen.com/nesug/nesug07/ap/ap19.pdf