Date: Tue, 12 Sep 2000 09:02:32 -0700 "Huang, Ya" "SAS(r) Discussion" "Huang, Ya" Re: PROGRAMMING QUESTION To: John Smith multipart/alternative;

John,

This is a very good candidate for proc sql:

data xx; input num \$ letter \$ @@; cards; 1 1 2 A 2 B 2 C 3 D 3 E 3 F 4 G 4 H 4 I 5 J 5 K 5 L 6 M 6 N 6 O 7 P 7 Q 7 R 7 S 8 T 8 U 8 V 9 W 9 X 9 Y 9 Z 0 0 ;

options nocenter;

proc sql; select compress(n1.num||n2.num||n3.num) as dialnum, compress(n1.letter||n2.letter||n3.letter) as dialet from xx n1, xx n2, xx n3 where n1.num='9' and n2.num='1' and n3.num='2' ;

------------------------- The SAS System 08:41 Tuesday, September 12, 2000 7

dialnum dialet --------------------------------------------- 912 W1A 912 X1A 912 Y1A 912 Z1A 912 W1B 912 X1B 912 Y1B 912 Z1B 912 W1C 912 X1C 912 Y1C 912 Z1C

You should be able to modify it to fit 4 digit case.

HTH

Ya Huang

-----Original Message----- From: John Smith [mailto:anirdesh@HOTMAIL.COM] Sent: Tuesday, September 12, 2000 8:17 AM To: SAS-L@LISTSERV.UGA.EDU Subject: PROGRAMMING QUESTION

How many ( unique) times a number can be dialed ?

Let's say if you need to dial 912, it can be dialed as

(1) W1A, W1B, W1C X1A, X1B, Z1C, Y1A, Y1B, Y1C, Z1A, Z1B, Z1C

Let's say if you need to dial 6047, it can be dialed as

(2) M0GP, N0GP, O0GP M0HP, N0HP, O0HP M0IP, N0IP, N0IQ and so on....

Is there a way in SAS to code like this ( It's a combinations) ? 1 (one) & 0 (zero) are itself (it doesn't take any letters).

_________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.