Reduce Social Security Account Number (SSAN) to Final Four Digits
If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.
- Installations and Emergencies!
- The Learning Curve
- Deep Dives on Specific Features
- The Community Treasure Chest
- Word Warriors®
- Resource Library
- News and Updates
While SSANs aren't numbers in that they cannot be added or subtracted, there are times when treating them as though they are can be helpful. Extracting just the final four characters is one of those times.
In the Questionnaire, guide the data provider, the person answering the questions, to enter the SSAN in a single string of nine digits without hyphens, such as 123456789.
In the form, create a Field based on that Answer. First set the Format to (1000 no decimals), then choose the Nmbr radio button, and the Math tab.
In the Math window, select Remainder from the dropdown menu on the left side and use the green plus button to start to formula. Within the Remainder brackets, enter the Field selection from the left dropdown followed by the Label of the Question. After the comma enter 10000.
This is designed to divide the SSAN by 10,000 and then provide just the remainder, the final four digits, as the answer.
The screens should look like these:
tags: remainder, truncate, number, integer, ssan, social security, confidential