SAS Visual Analytics : Change Variable Classification

This tutorial explains how to change variable type (classification) from category to measure in SAS Visual Analytics.

Suppose you import a dataset in SAS Visual Analytics in which there is a numeric (continuous) variable that is stored as character (or classified as "Category"). You want to convert it to numeric ( "measure"). By default, you cannot change the variable format from "category" to "measure".

We can solve this problem by creating a new calculated data item using the PARSE function.

Step I :
Select Data >> New Calculated Item (See the image below)

SAS Visual Analytics : New Calculated Item
Step 2 :
Enter a Name for the calculated item
Step 3 :

Enter the Parse function under the 'Text' section. In the following function, 'Order' is the variable that we want to change it from category to measure.
Parse('Order'n, 'F12.')
Change Variable Classification

Love this Post? Spread the Word!
Comment and share to motivate us to write more!
About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 8 years of experience in data science. During his tenure, he has worked with global clients in various domains like Banking, Insurance, Telecom and Human Resource.

While I love having friends who agree, I only learn from those who don't.

Let's Get Connected: Email | LinkedIn

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*
Related Posts:
1 Response to "SAS Visual Analytics : Change Variable Classification"
  1. I have seen similar conversion from date to number being done with TreatAs function as well, see

    Do you know if these can be used to create calculated measures and/or categories in OLAP Cube Studio as well?


    Chad Caulkins


Next → ← Prev
Scroll to Top