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-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

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
  • 605 views
  • 0 likes
  • 4 in conversation