Are the behaviors of the operators in expressions the same for SAS and CASL?  SAS https://go.documentation.sas.com/doc/en/lrcon/9.4/p00iah2thp63bmn1lt20esag14lh.htm   CASL https://go.documentation.sas.com/doc/en/pgmsascdc/v_042/caslpg/n1nlmx3yjfv9vrn1xykzhdfu7jgj.htm   Do they all work the same way in CASL and SAS consistently and to produce the same results? Can anyone confirm this?    The pages show there are some differences. I'm noticing that in CASL, for example the comparison operator Not Equal to is != but it doesn't work in CASL, it only works with mnemonics like NE, or I need to use the same operator as SAS which is ^=. Has anyone been able to get != to run in CASL?  ... View more

What is the SAS datetime informat for the datetime value of 2021/08/19 18:00:54+00?  I have tried the ISO8601 datetime informat and datetime20. format but that does not work. The column is a double and has a date format but all the values in the column are NaT I am using SAS Viya for Python ... View more

I am trying to convert a column containing date values in the following format to MM/DD/YYYY. The values look like this in the raw CSV data.  After loading the raw data into a CAS table, this column is a VARCHAR, I would like to either import the values as numeric MM/DD/YYYY or create a separate column that is a Numeric that only has values in this format: MM/DD/YYYY Is there a  way to do this as part of a CAS Action?  Thanks.  ... View more

I'm trying to understand how the whereTable paramater in CAS actions works in detail.  Why would the whereTable parameter be used instead of using the WHERE expression? what are the possible limitations of using the whereTable parameter and how does it operate specifically? There isn't detailed information about whereTable in the Help center documentation. ... View more