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

Related Posts
About Author:

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

2 Responses 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

  2. what is the difference between SAS LASR Server and SAS public LASR Server?

    Please answer


Next → ← Prev
Love this Post? Spread the Word!