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 (September 2006, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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.


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