Hello,   I am referencing to a 2016 article "Finding a value in all datasets in all variables."   I do not use PROC IML but we are licensed for this product.   My goal is to find a specific value '024683579' in variable TABNC in library QPPCT.  The library QPPCT has over 9K datasets with nearly all of them having the same variable TABNC.  I need the name of the dataset(s) found and the creation date.  The purpose is to find a specific (or multiple) datasets with this value.   Can the 2016 solution be adapted for this use or is there a better way to do this?   Thank you, Curtis ... View more

I have an user who wants to round down any values between .45 and .49.  The user doesn't want it to automatically round up to .5.   How do I check on decimal points only for any decimal values between .45 and .49 and then round down to .4?   Thank you. ... View more

This morning's (03/15/2023) announcement that there is a new version of SAS Private JRE for SAS 9.4M7.  I do not see an announcement for SAS 9.4M8 which uses Java 11.  Is there an update for SAS Private JRE for SAS 9.4M8?  Thanks.   Updates available for the SAS Private JRE ... View more

Hello,   I followed the instructions outlined in https://support.sas.com/kb/40/012.html on setting Java options to -Xmx512M for SAS Deployment Manager.   However, due to the way the SDM works on updating the SAS Java Private Runtime (JRE) to the latest JRE version, it reverts back to -Xmx1024M and it fails.   The first time I start SDM, I provide the location to where the JRE update is located. INFO: Launcher::Run::start::Run with stdout="C:\Program Files\SASHome\SASDeploymentManager\9.4\products\privatejre__99573__wx6__xx__sp0__1\bin\java.exe" -Xmx512M "-Djavax.net.ssl.trustStore=C:\Program Files\SASHome\SASPrivateJavaRuntimeEnvironment\9.4\jre\lib\security\jssecacerts" -Xmx512M -jar "C:\Program Files\SASHome\SASDeploymentManager\9.4\products\deploywiz__94588__prt__xx__sp0__1\deploywiz\setup.jar" -startuplocation "C:\Program Files\SASHome\SASDeploymentManager\9.4" -configure -javaoptions "-Xmx512M"   SDM automatically closes itself and starts another instance of SDM.  The second instance of SDM consistently fails: INFO: Launcher::Run::start::Run with stdout="C:\Program Files\SASHome\InstallMisc\SASDeploymentManager\jre\bin\java" -Xmx1024M -jar "C:\Program Files\SASHome\InstallMisc\SASDeploymentManager\deploywiz\setup.jar" -startuplocation "C:\Program Files\SASHome\SASDeploymentManager\9.4" -configure -javaoptions -Xmx512M -sdmrestartedfromaltlocation -lang en -hotfixdir "C:\SAS HotFixes\JRE_180_332" -partialprompt -responsefile "C:\Program Files\SASHome\InstallMisc\SASDeploymentManager\sasdm.response.txt" How can I get the second instance of SDM to configure to use -Xmx512M so I can perform the Private JRE update?   Thank you. ... View more

Hello, I just wanted to be sure that I cannot use SAS variables in an IN operator in a Data Step?   Let's say that I have 3 SAS variables:   a = 'Mazda'; b = 'Kia'; c = 'Nissan'; if MAKE in (a, b, c);   I get a syntax error.   I know I can write as literals: if MAKE in ('Mazda', 'Kia', 'Nissan'); I wanted to verify that using SAS variable is not possible in a DATA step.  Thanks. ... View more