Hi, I'm trying to read raw data file which is .txt file Frankfurt,Freight,Direct,$1,464,938 Frankfurt,Freight,Indirect,$198,942 Frankfurt,Freight,Other,$144,685 Frankfurt,Other,Direct,$111,193 Frankfurt,Other,Indirect,$12,057 Frankfurt,Other,Other,$10,717 I'm tried the below syntax: data revenue;
infile "file-path/file.txt" dlm=",";
input City $ Transport $ Type $ Amount:dollar12.;
run; my output is City Transport Type Amount Frankfur Freight Direct 1 Frankfur Freight Indirect 198 Frankfur Freight Other 144 Frankfur Other Direct 111 Frankfur Other Indirect 12 Frankfur Other Other 10 As you can see, in the amount variable data values are displayed wrongly. for the value $1,464,938 the numbers after first comma are missing in my output. How to overcome this? if there is delimiter in the same variable how to write the syntax for that?
... View more