topic Converting string to numeric using query builder in SAS Enterprise Guide

Converting string to numeric using query builder

anonymous_user — Thu, 17 Nov 2016 13:08:36 GMT

Is there any way to do this? I tried a computed column OLD_VAR * 1 but got the error attached, I want to do this on point click because is faster than creating a program just to convert one var.

Re: Converting string to numeric using query builder

ChrisHemedinger — Thu, 17 Nov 2016 13:18:17 GMT

You can do it by defining an Advanced Expression as a calculated column with the INPUT function, using something like:

input(t1.CNPJ_CPF,best12.)

(replace "best12" with appropriate informat spec to get the precision you need).

Re: Converting string to numeric using query builder

anonymous_user — Thu, 17 Nov 2016 16:48:44 GMT

Thanks Chris !! 😉