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