topic sas function in New SAS User

sas function

timmy555 — Wed, 04 Dec 2019 04:15:30 GMT

I have a dataset in which the social security number names the variable soc is in the format 55555555. But I need it to be the usually for

SASKiwi — Wed, 04 Dec 2019 03:44:22 GMT

I suspect your variable SOC is character. It needs to be a number to apply the SSN format:

data want;
  set have (obs= 10);
  socialsecurity=input(soc, best12.);
  format socialsecurity ssn11.;
  put socialsecurity = ;
run;

Jagadishkatam — Wed, 04 Dec 2019 03:53:09 GMT

Please try the below untested code

data have;
x='555555555';
y=prxchange('s/(\d{3,3})(\d{2,2})(\d{4,4})/$1-$2-$3/',-1,x);
run;

timmy555 — Wed, 04 Dec 2019 03:49:10 GMT

is there another way to apply the dashes through a function procedure?

timmy555 — Wed, 04 Dec 2019 03:53:14 GMT

I figured it our thankyou needs the input and put function.

Jagadishkatam — Wed, 04 Dec 2019 03:54:50 GMT

You can also try the perl regular expression incase you havent tried the code i posted.