topic Re: Adding characters to a string in SAS Programming

Adding characters to a string

marianhabesland — Wed, 11 Oct 2017 00:00:59 GMT

I am supposed to create a variable called SSN2. I currently have a variable called SSN that has the social security numbers in a format XXXXXXXXX, and want SSN2 to be in the format XXX-XX-XXXX, in other words adding hyphens in specific positions. I have tried using the CATX function, but I don't know if this is even the right function as I am just splitting the one variable up. Should I instead be using the SUBSTR function?

Re: Adding characters to a string

Reeza — Wed, 11 Oct 2017 00:04:20 GMT

Or neither, use a format. SAS even has a format...

https://support.sas.com/documentation/cdl/en/leforinforref/64790/HTML/default/viewer.htm#n1sroiq0fqlgncn1d52g0go5xqeq.htm

Convert your SSN to numeric using INPUT and then apply the format.

Re: Adding characters to a string

TarunKumar — Wed, 11 Oct 2017 12:34:22 GMT

data have;
input ss_no $9.;
datalines;
absdefght
abadefght
absdefgtk
absdefgtp
absdefert
asedrftgh
potrpshrt
;run;

data want;
set have;
ss_no_new = catx("-",substr(ss_no,1,3),substr(ss_no,4,2),substr(ss_no,6,4));
run;