I am trying to import a dataset in VA, which is being recognised as category since the data is alphanumeric. I want to get this column defined as a measure. Since the display required is to show these values as it is, against a combination of parameters. Wanted to build a cross tab report.
They way forward could be by using Parse operator. F.ex. if you have Category for Cruise ship cabins and the data looks something like this Text A = [A123, A154, B129, C3021, C3122,...], you can first use Substring operator to get the number part and then cast it into a number type variable using Parse:
Thanks Petri, for your suggestion. I actually have values coming in from various systems and the values are alphanumeric, For eg, I have some values like CHQ114, A679, 9769, CBH. These values are connected to various categories and depending on the category value the measure value is to be reported. Issue is that the value column is alphanumeric and therefore being treated as category.
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.