Date:         Tue, 19 Sep 2006 04:28:27 -0400
Reply-To:     Ummeed Nandkeolyar <ummeed_n@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ummeed Nandkeolyar <ummeed_n@YAHOO.COM>
Subject:      How to convert a character string consisting of numbers to a long
              number of width 15 or more in SAS ETL Studio???

Hello,
I have been trying to read from a csv file a value of 567237891205.000 as
follows:
a=input(b,20.)
where b is a character string.

But while its reading the numbers having width greater than 7 digits, it
leaves a blank in case of numbers having lesser digits.
For example:
CSV Data :
1  123.000
2  567237891205.000
3  83455.000
4  45619328445.000
5  2375993.000
6  73.000

final dataset:
1
2 567237891205.000
3 83455.000
4  45619328445.000
5  2375993.000
6


I was told a colon modifier can correct this but how and where does one use
it in a SAS ETL job. i am using a "file reader" to read from the csv file
and a loader to load into the final sas dataset.

Please help.