If the data consistently includes FEET value then you could use something like this: data check; input charvar $10.; inches = sum (12*input(scan(charvar,1,'"'''),5.) ,input(scan(charvar,2,'"'''),5.) ) ; put (inches charvar) (=); cards; 5' 8" 4' run; inches=68 charvar=5' 8" inches=48 charvar=4'
... View more