| Date: | Tue, 12 Sep 2000 17:04:42 GMT |
|---|
| Reply-To: | John Smith <anirdesh@HOTMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | John Smith <anirdesh@HOTMAIL.COM> |
|---|
| Subject: | Re: PROGRAMMING QUESTION |
|---|
|
| Content-Type: | text/plain; format=flowed |
|---|
THANKS A MILLION $$$$$$$$$$$$$$$$$
IT'S A GREAT & EFFICIENT CODE !!!!!!!!!!!
>From: "Huang, Ya" <ya.huang@Agouron.COM>
>To: "'John Smith'" <anirdesh@HOTMAIL.COM>, SAS-L@LISTSERV.UGA.EDU
>Subject: RE: PROGRAMMING QUESTION
>Date: Tue, 12 Sep 2000 09:02:32 -0700
>MIME-Version: 1.0
>Received: from [198.182.177.3] by hotmail.com (3.2) with ESMTP id
>MHotMailBB879E9A0046D821EEB2C6B6B1031C7F0; Tue Sep 12 09:02:35 2000
>Received: from relay.agouron.com by tbone.agouron.com via smtpd
>(for mc22.law5.hotmail.com [216.33.238.137]) with SMTP; 12 Sep 2000
>16:02:34 UT
>Received: (private information removed)
>Received: (private information removed)
>From ya.huang@Agouron.COM Tue Sep 12 09:03:50 2000
>Message-ID: <79A739F5800AD411B65E00D0B741D3B16777FF@currency.agouron.com>
>X-Mailer: Internet Mail Service (5.5.2650.21)
>
>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.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
|
