| Date: | Fri, 12 May 2000 17:00:37 +0200 |
| Reply-To: | Niels Stout <n.stout@VOLTAIRE.NL> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | Niels Stout <n.stout@VOLTAIRE.NL> |
| Organization: | IntroWeb Newsserver |
| Subject: | Re: Numerical---Numerical? |
|---|
Hi James,
use the input function:
all = input(put(grade,z2.)!!put(class,z2.)!!put(group,z2.),6.);
cheers,
Niels
James Yang <jamesy99@HOTMAIL.COM> wrote in message
news:20000512144237.97540.qmail@hotmail.com...
> 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
>
> So I want to add leading 0 to these three vars to get the expected value
of
> ALL. After that, I can choose records by compare ALL. For example, I will
> extract records where ALL>081010. Then 2 and 3 will be selected.
>
> So how to make this? I tried following:
> grade1 = put(grade, z2.);
>
> But when I check, the grade1 is character but not numerical var. If any
> expert can provide your valuable suggestion and advice, it would be
greatly
> appreciated. Thanks again.
>
> Regards,
> James
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
|