topic Re: function in SAS Programming

function

timmy555 — Wed, 04 Dec 2019 04:14:50 GMT

Posts: 4

function

2m ago

Re: function

Jagadishkatam — Wed, 04 Dec 2019 04:06:01 GMT

Please try the below code

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

Re: function

Jagadishkatam — Wed, 04 Dec 2019 04:11:38 GMT

you can also try the picture format as below, but you need the numeric data

proc format;
picture phone (default=16)
low-high='999)-999-9999' (prefix='(');
run;
quit;


data have;
x=6666666666;
y=put(x,phone.);
run;

Re: function

Kurt_Bremser — Wed, 04 Dec 2019 08:16:43 GMT

Please do not edit initial thread posts, especially do not completely remove the original content. This is considered rude behavior vs. everyone involved in the discussion.

Re: function

Kurt_Bremser — Wed, 04 Dec 2019 08:17:50 GMT

And use descriptive subject lines. "function" is NOT descriptive.