- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
the newly created item _ch_numvar is categorical.
This is achieved by using the format operator on a numerical variable. give it a try
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content