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.
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
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
I apologize it is the other way around numeric to character. Sorry about that and thanks for the quick response
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
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.