LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (June 2007, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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>
Subject:      Re: data conversion
In-Reply-To:  <>
Content-Type: text/plain; format=flowed; charset="iso-8859-1";

Hi Xiao,

You can use my Notebook ( 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!


----- 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

Back to: Top of message | Previous page | Main SAS-L page