SAS Visual Analytics

Dashboards, reports, BI and analytics - all from a single interface.
BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
jpapaiac
Fluorite | Level 6

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.

1 ACCEPTED SOLUTION

Accepted Solutions
FalkoSchulz
SAS Employee

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

View solution in original post

5 REPLIES 5
FalkoSchulz
SAS Employee

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

jpapaiac
Fluorite | Level 6

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

jpapaiac
Fluorite | Level 6
I apologize it is the other way around numeric to character. Sorry about that and thanks for the quick response
ThdB
Obsidian | Level 7

you can use the Format function for this

JoyCons
Calcite | Level 5

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

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 2090 views
  • 0 likes
  • 4 in conversation