Date:         Mon, 18 Jun 2007 16:20:50 -0400
Reply-To:     "Audimar P. Bangi" <audi@SAS2THEMAX.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Audimar P. Bangi" <audi@SAS2THEMAX.COM>
Organization: sas2themax.com
Subject:      Re: data conversion
In-Reply-To:  <200706181804.l5II3jhY008293@mailgw.cc.uga.edu>
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
              reply-type=original

Hi Xiao,

You can use my Notebook (http://sas2themax.com/beta) to do type conversions
in you data file.

Open your data file (click on the "Data Editor" tab and then the "Open Data
File" button)
Or you can open a new datasheet and copy-paste your data values onto the new
datasheet
Right-click on the column you want to convert to numeric. Select "Column
Attributes".
Under the "Type" combobox, select "Numeric".
Under the "Format Decimal", set the value to "2".
If the leading zeros need to be preserved, set the "Format Name" to "Z".
Click on the "Apply" button.
Now you can save your data file as a SAS dataset (*.sas7bdat) -- no DATA
step required!

Audi
http://sas2themax.com


----- Original Message -----
From: "Xiao Tang" <glionswiss@GMAIL.COM>
To: <SAS-L@LISTSERV.UGA.EDU>
Sent: Monday, June 18, 2007 2:04 PM
Subject: data conversion


>I have some data following, and they are all text vaule. I want to convert
> to numeric value and i get all the value equals zero when i use input
> function.
>
> 000000000005.00
> 000000000025.12
> 000000000125.13
> 000000000000.91
>
> Xiao Tang