No, you have to create a new data item.
call it character expression of your numerical variable.
use the FORMAT operator and place the numerical variable inside, choose best12. for the format.
this newly created data item works in hierarchies.
I don't understand 100% your question.
BUT perhaps this may be your solution:
Depending on the context the "convert to category" option still treats the "categorical" variable as numeric preventing you from using it in a hierarchy for example.
You can overcome this by creating a categorical expression of your numerical variable by creating a calculated item "_ch_numvar" in this manner:
format(numeric_variable, best12.)
then it behaves like truly categorical
the newly created item _ch_numvar is categorical.
This is achieved by using the format operator on a numerical variable. give it a try
No, you have to create a new data item.
call it character expression of your numerical variable.
use the FORMAT operator and place the numerical variable inside, choose best12. for the format.
this newly created data item works in hierarchies.
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.