SAS Visual Analytics : Convert Numeric Variable to Date

This post describes how to convert a numeric variable to date format in SAS Visual Analytics.

Task

Suppose a variable having date information is classified as a measure (numeric) variable type in SAS Visual Analytics . The task is to convert it to Date format variable.

Solution

We can create a new calculated data item using the TreatAs Numeric(advanced) operator.

Step I

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

New Calculated Item

Step II

Enter a Name for the calculated item

Step III

Enter the TreatAs function under the 'Numeric(advanced)' section. In the image shown below, 'Period_Num' is the variable that we want to change it from numeric to date.

SAS VA : Convert Numeric to Date

Spread the Word!
Share Share Tweet

About Author:
Deepanshu Bhalla

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.

While I love having friends who agree, I only learn from those who don't
Let's Get Connected Email LinkedIn

2 Responses to "SAS Visual Analytics : Convert Numeric Variable to Date"

Mueeid SoomroSeptember 21, 2017 at 8:21 PM
Even though you had a feeling that web analytics could help your business, the task of choosing a program and installing the program and maintaining the program just seemed too daunting to undertake.call center dashboards
Innocent MkSeptember 21, 2017 at 10:41 PM
All organizations in all industries generate data, and the volumes are growing exponentially. bank and financial dashboards