BookmarkSubscribeRSS Feed
timmy555
Calcite | Level 5
 
Posts: 4
 
function
 

b

4 REPLIES 4
Jagadishkatam
Amethyst | Level 16

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;
Thanks,
Jag
Jagadishkatam
Amethyst | Level 16

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;
Thanks,
Jag
Kurt_Bremser
Super User

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.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 769 views
  • 2 likes
  • 3 in conversation