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 (November 2003, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 24 Nov 2003 16:32:52 -0500
Reply-To:     Peter Crawford <peter@CRAWFORDSOFTWARE.DEMON.CO.UK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <peter@CRAWFORDSOFTWARE.DEMON.CO.UK>
Subject:      Re: help
Comments: To: Zhonghe Li <zli@HSPH.HARVARD.EDU>

On Mon, 24 Nov 2003 16:00:41 -0500, Zhonghe Li <zli@HSPH.HARVARD.EDU> wrote:

>hi everyone, > >we got a tab-delimited file and the data was imported with > > >proc import datafile="c:\Projects\Meredith\Mercer Project\Original data >files\extract8900.txt" >out=mercer.RFIHMO >dbms=tab >replace; >run; > >Then the imported organization ID is in the format of 1.000185E24. So I >created a new orgID as > >orgID=put(organizationID, 32.); > >However, when I check the orgID with the original organization ID that was >in the tab-delimited text file, they are different. >orgID=1000185000001000051834880 but the original= >000001000185000001000000000000 > >I don't know where those 51834880 came from as these numbers were not shown >in the text file. > >Thank you very much. > >Elena

Hi Elena

discover the option to save source code for importing the data Change ithat source code to read orgID as $30. In the online doc see the example at http://v8doc.sas.com/sashtml/proc/z0308092.htm

Good Luck Peter Crawford


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