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

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 worked with global clients in various domains like Banking, Insurance, Private Equity, Telecom and HR.

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