Hello, I am currently working in DiStudio and am reading in a SAS dataset that has a numeric value. I'm trying to create a 'verification' job that looks to see the number of digits before and after the decimal and flag any that are not accurate. I've done this before, but the field was a character field and not numeric. For example, we have a table of values and the ones that appear in a numeric column are as follows: 1.1230 1.784 1.1487 We want to find all decimals without four decimals (ie 1.784) However, when I do (LENGTH(SCAN(PUT(X,best.),2,'.')) ^= 4, it flags both 1.784 and 1.1230 since best drops the trailing zero. Would somebody be able to help me figure out how I can find the digits after the decimal place in the WHERE tab of DiStudio?
... View more