function

[timmy555]

Posts: 4

function

Options

2m ago

b

[timmy555]

b

[Jagadishkatam]

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;

[Jagadishkatam]

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;

[Kurt_Bremser]

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.

[Kurt_Bremser]

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