Date:         Fri, 12 May 2000 10:12:28 -0500
Reply-To:     Henry Feldman <hfeldman@CONCEPTUAL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Henry Feldman <hfeldman@CONCEPTUAL.COM>
Subject:      Re: Numerical---Numerical?
Comments: To: James Yang <jamesy99@HOTMAIL.COM>
In-Reply-To:  <20000512144237.97540.qmail@hotmail.com>
Content-Type: text/plain; charset="us-ascii"; format=flowed

At 10:42 AM 5/12/00 -0400, you wrote:

>I hava a sas dataset imported from Access. All three vars: Grade, class, and
>group are numerical with both format and informt are best8.. Supposing
>following is the value:
>
>Grade class group
>1      1     1
>8      10    13
>12     11    10
>
>What I want to do is to get a new numerical var(ALL) by combining these
>three variable and make it compariable. That is:
>
>Grade class group  all
>1      1     1     010101
>8      10    13    081013
>12     11    10    121110


How about

all = grade1 * 10000 + grade2 * 100 + grade3;

That gives you a number.

Henry

----------------------------------------------
Henry Feldman              henry@conceptual.com
Conceptual Software, Inc.     (713) 721-4200
9660 Hillcroft #510       fax:(713) 721-4298
Houston, TX  77096       web: http://www.conceptual.com/
----------------------------------------------