SSN QC - SAS Support Communities

Quartz | Level 8

Quartz | Level 8

SSN QC

Posted 10-27-2014 01:39 PM (1292 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 (1226 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 (1226 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 (1226 views) | In reply to SASPhile

I found one by googling:

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

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!