Hi,
I have tables with character columns for SSNs. I will like to build a format to have those numbers look like actual SSNs with the dashes, but still be a chracter column, not numeric.
SSNs_as_I_have_them | SSNs_as_I_want_them |
---|---|
001234567 | 001-23-4567 |
123456789 | 123-45-6789 |
999999999 | 999-99-9999 |
I have never build a format before. Any help?
Thanks!
Use the SAS supplied format in a data step after temporarily treating SSN as numeric.
SSN_as_wanted = put(input(ssn,best.), ssn11.);
Use the SAS supplied format in a data step after temporarily treating SSN as numeric.
SSN_as_wanted = put(input(ssn,best.), ssn11.);
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.