It looks like you are trying to use a numeric format with character data. Try converting your string to a number before you issue the transform command.

x=1234567
? transform(x,'@R (999) 999-9999')
produces ( ) 123-4567

but

x="1234567"
? transform(x,'@R (999) 999-9999')
produces (123)456-7

- Don