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???
I have been trying to read from a csv file a value of 567237891205.000 as
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.
CSV Data :
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.