topic Re: Formatting Phone Numbers with separated area codes in SAS Programming

Formatting Phone Numbers with separated area codes

Ahzu — Tue, 03 Oct 2017 01:39:09 GMT

I am having trouble trying to convert phone numbers into the following format:

(xxx) xxx-xxxx

datalines;
9136122 Code=999 Date=6/30/2001
;

The outputted format I want is:

Phone = (999) 913-6122

Date = June 30, 2001

I am not sure how to deal with converting 'Code=999' as the area code.

Thanks.

Re: Formatting Phone Numbers with separated area codes

Reeza — Tue, 03 Oct 2017 02:47:11 GMT

Please post sample data that accurately reflects your data. I can't tell if you have three variables or one variable.

This paper walks through the different ways to format your phone number.

http://www2.sas.com/proceedings/sugi31/243-31.pdf

Re: Formatting Phone Numbers with separated area codes

mkeintz — Tue, 03 Oct 2017 02:52:24 GMT

You have a choice of

making the phone number a numeric value with 10 digits (10000000*acode+pnum), and assigning it a format to produce your desired layout, or
creating a character variable with the parentheses, dash, and internal blank. You can do the latter using a couple of CATS functions nested inside a CATX function. For example the area code part could be CATS('(',acode,')').

Re: Formatting Phone Numbers with separated area codes

kiranv_ — Tue, 03 Oct 2017 03:11:48 GMT

something like this

data want;
input phone $ 1-17 date1 $ 18-33 ;
phone = cat('(',substr(trim(phone),14),') ', substr(phone,1,3), '-',substr(phone,1,4));
date= input(substr(date1,6),mmddyy10.);
format date worddate20.;
drop date1;
datalines;
9136122 Code=999 Date=6/30/2001
;

Re: Formatting Phone Numbers with separated area codes

ChrisNZ — Tue, 03 Oct 2017 05:13:30 GMT

Your program outputs what you request. What's the issue?

phone	date
(999) 913-9136	June 30, 2001

Oh wait, not quite...

Like this?

  PHONE = cat('(',scan(PHONE,2,'='), ') ', substr(PHONE,1,3), '-',SUBSTR(PHONE,4,4));

PHONE	DATE
(999 ) 913-6122	June 30, 2001

Re: Formatting Phone Numbers with separated area codes

Astounding — Tue, 03 Oct 2017 06:44:34 GMT

SAS lets you read this type of data directly. Here's the documentation:

http://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.2&docsetId=lestmtsref&docsetTarget=p1jjrvmzmybdeqn1gt8gj1r0ed0u.htm&locale=en#p0bj1u9rp3n45in1j19p677jp6ik