Date:         Tue, 4 Nov 2008 17:32:43 -0600
Reply-To:     "./ ADD NAME=Data _null_," <iebupdte@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "./ ADD NAME=Data _null_," <iebupdte@GMAIL.COM>
Subject:      Re: how to convert char ID to number ID
Comments: To: jn_mao@yahoo.com
In-Reply-To:  <739198.25476.qm@web32704.mail.mud.yahoo.com>
Content-Type: text/plain; charset=ISO-2022-JP

newID = input(compress(id,,'KD'),f8.);

On 11/4/08, jn mao <jn_mao@yahoo.com> wrote:
> Hello SAS-Ls,
>
> I have a large SFX file. After I extracted it, the ID data were shown with a spuare before the number, like " $B8} (B23444412" .  It was also shown character type in SAS contents.
> After I tried 'input' to convert it to number in newID, it doesn't work. The newID has all missing data.  Could anyone tell me what data type of this ID is? How can I convert it to normal number data type?
>
> I tried
> newID=input(ID, best8.); but this doesn't work.
>
> Thanks much!
>
> Jane
>
>
>
>