topic Convert Character to numeric SAS VA on Viya in SAS Visual Analytics

Convert Character to numeric SAS VA on Viya

jpapaiac — Tue, 08 Aug 2023 01:11:13 GMT

I have a numeric measure field and I want to convert it to character. The reason is I need to add the field on a row in crosstab.

Re: Convert Character to numeric SAS VA on Viya

FalkoSchulz — Tue, 08 Aug 2023 01:17:33 GMT

Hi, this should be straight forward. You can either just switch the data item classification to category in the left data pane (find your item - then expand the section to see the classification) - or create a new calculated item and use the Format function to convert your numeric item to character. If you want to convert a character to numeric - you can use the Parse function. Hope this helps. Falko

Re: Convert numeric to character SAS VA on Viya

jpapaiac — Tue, 08 Aug 2023 01:55:03 GMT

I apologize it is the other way around numeric to character. Sorry about that and thanks for the quick response

Re: Convert Character to numeric SAS VA on Viya

jpapaiac — Tue, 08 Aug 2023 01:57:19 GMT

I apologize it is the other way around numeric to character. Sorry about that and thanks for the quick response

Re: Convert Character to numeric SAS VA on Viya

JoyCons — Thu, 30 Nov 2023 17:01:20 GMT

Hello,

I am trying to convert a character to numeric using the parse function. Can you direct me to a link that provides instruction on using the parse function in SAS Viya?

V/R,

JoyCons

Re: Convert Character to numeric SAS VA on Viya

ThdB — Thu, 07 Dec 2023 11:54:35 GMT

you can use the Format function for this