Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

List of functions and Syntax for the Data Prep module of SAS VA 8.2

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

List of functions and Syntax for the Data Prep module of SAS VA 8.2

With the recent upgrade to SAS VA 8.2 ( from 8.1), I noticed that Data preparation replaced the data module builder. I was surprised to observe that the new module stripped away the GUI interface for Data Transformations. Not being a core SAS user, I am now left trying to figure out what functions ( and their respective syntax) are available for use in Calculated Columns functions. The help icon was not helpful as it took me to Data Studio's guide and to the Data Step command, which is not what I assume goes into the Calculated Columns function. 

 

Wondering if there is a list available of functions and their respective syntax?


Accepted Solutions
Solution
‎03-13-2018 04:57 PM
SAS Employee
Posts: 42

Re: List of functions and Syntax for the Data Prep module of SAS VA 8.2

The language that is used in the calculated columns transform is CAS datastep.  You can find a function reference here:

 

SAS Functions and CALL Routines by Category

 

Note that not all datastep functions are supported in CAS but many of them are.   Thanks for providing the feedback, and we do plan to provide an expression builder in a future release.  

 

 

View solution in original post


All Replies
Solution
‎03-13-2018 04:57 PM
SAS Employee
Posts: 42

Re: List of functions and Syntax for the Data Prep module of SAS VA 8.2

The language that is used in the calculated columns transform is CAS datastep.  You can find a function reference here:

 

SAS Functions and CALL Routines by Category

 

Note that not all datastep functions are supported in CAS but many of them are.   Thanks for providing the feedback, and we do plan to provide an expression builder in a future release.  

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 156 views
  • 0 likes
  • 2 in conversation