I have a .csv file that I'm importing into SAS using the infile statement. There are a few columns that have data formatted as a percent, but the percentages in the raw data don't always show 2 decimal places, so "6.00%" is writen as "6%".
I'm importing the data in an infile datastep so I have the informat set at percent3.2 for those fields. The import runs without any errors, however when I check the SAS data set the percentages without any decimal places are imported incorrectly.
For example:
"6%" gets read as .0006
-but-
"6.12%" gets read in correctly as .0612
I need the "6%" to be read in as .06. Any ideas how I can fix this?
Sample of my code:
data work.MyDataset;
%let _EFIERR_ = 0;
infile 'C:\MyFile.csv'
delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
informat OldInterestRate percent3.2 ;
informat NewInterestRate percent3.2 ;
format OldInterestRate 10.6 ;
format NewInterestRate 10.6 ;
.....