https://communities.sas.com/t5/SAS-Visual-Analytics/List-of-functions-and-Syntax-for-the-Data-Prep-module-of-SAS-VA/m-p/441645#M9595 <P>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&nbsp;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.&nbsp;</P><P>&nbsp;</P><P>Wondering if there is a list available of functions and their respective syntax?</P> Fri, 02 Mar 2018 17:14:43 GMT don_data 2018-03-02T17:14:43Z https://communities.sas.com/t5/SAS-Visual-Analytics/List-of-functions-and-Syntax-for-the-Data-Prep-module-of-SAS-VA/m-p/441645#M9595 <P>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&nbsp;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.&nbsp;</P><P>&nbsp;</P><P>Wondering if there is a list available of functions and their respective syntax?</P> Fri, 02 Mar 2018 17:14:43 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/List-of-functions-and-Syntax-for-the-Data-Prep-module-of-SAS-VA/m-p/441645#M9595 don_data 2018-03-02T17:14:43Z https://communities.sas.com/t5/SAS-Visual-Analytics/List-of-functions-and-Syntax-for-the-Data-Prep-module-of-SAS-VA/m-p/444288#M9666 <P>The language that is used in the calculated columns transform is CAS datastep.&nbsp; You can find a function reference here:</P> <P>&nbsp;</P> <P><A title="SAS Functions and CALL Routines by Category" href="http://go.documentation.sas.com/?docsetId=lefunctionsref&amp;docsetTarget=n01f5qrjoh9h4hn1olbdpb5pr2td.htm&amp;docsetVersion=9.4&amp;locale=en#n0c222bajltgewn17ytfxpjmu3hi" target="_self">SAS Functions and CALL Routines by Category</A></P> <P>&nbsp;</P> <P>Note that not all datastep functions are supported in CAS but many of them are. &nbsp; <SPAN>Thanks for providing the feedback, and we</SPAN> do plan to provide an expression builder in a future release. &nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 09 Mar 2018 22:06:19 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/List-of-functions-and-Syntax-for-the-Data-Prep-module-of-SAS-VA/m-p/444288#M9666 nar_sas 2018-03-09T22:06:19Z