|
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.
|