Hello. I don't know in what board I should post this, there doesn't seem to be a good fit.   I used to work on SAS from a jupyter lab notebook (the same happens with the old jupyter notebook). A few weeks ago IT had to reinstall SAS on my Windows 10 Machine. Since then, when I try to run any SAS code in a notebook, I get the following. (The image is large enough, but this seems to shrink it to the point where it is unreadable). Here's the wall of text I get:   The application could not log on to the server. The server process did not start. SAS process has terminated unexpectedly. RC from wait was: 4294967290 SAS Connection failed. No connection established. Double check you settings in sascfg.py file. Attempted to run program C:\Program Files\SASHome\SASPrivateJavaRuntimeEnvironment\9.4\jre\bin\java.exe with the following parameters:['C:\\Program Files\\SASHome\\SASPrivateJavaRuntimeEnvironment\\9.4\\jre\\bin\\java.exe', '-Dcom.sas.iom.orb.brg.zeroConfigWorkspaceServer.sascmd="C:\\Program Files\\SASHome\x86\\SASFoundation\\9.4\\sas.exe"', '-classpath', 'C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94390__prt__xx__sp0__1\\deploywiz\\sas.svc.connection.jar;C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94390__prt__xx__sp0__1\\deploywiz\\log4j.jar;C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94390__prt__xx__sp0__1\\deploywiz\\sas.security.sspi.jar;C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94390__prt__xx__sp0__1\\deploywiz\\sas.core.jar;C:\\ProgramData\\Anaconda3\\Lib\\site-packages\\saspy\\java\\saspyiom.jar', 'pyiom.saspy2j', '-host', 'localhost', '-stdinport', '61493', '-stdoutport', '61494', '-stderrport', '61495', '-zero', ''] Be sure the path to sspiauth.dll is in your System PATH No SAS process attached. SAS process has terminated unexpectedly. No SAS process attached. SAS process has terminated unexpectedly. No SAS process attached. SAS process has terminated unexpectedly. No SAS process attached. SAS process has terminated unexpectedly. No SAS process attached. SAS process has terminated unexpectedly. No SAS process attached. SAS process has terminated unexpectedly. Restarting SAS session on your behalf in shutdown function Restarting kernel... Done!  I have made sure sspiauth.dll is in mine System PATH:   Something else that might be relevant is that I have three different deploywiz folders. I've tried editing sascfg.py to each of them specifically and the result was the same with all of them.  This problem seems to be the same that is troubleshooted in this link, point 5. I have also followed the instructions there, but they didn't help me. Here's what I see in my registry:  When I run  "C:\Program Files\SASHome\x86\SASFoundation\9.4\sas.exe" /regserver Nothing seems to happen as you can see in the gif below. And after doing all this, I still get the same problem I showed at the top.   This is my SAS version.   I don't know what else to try. Any help? ... View more

I'm trying to chain format changes to go from a date in Date9. format to a character variable which will be the year-month variable of the same date. For example, starting from 05OCT2017 (date type), I want to end up with 201710.   I don't want do this with intermediary data steps and I want to do it in PROC SQL while avoiding subqueries as well. It seemed natural to try the following, but this syntax isn't valid. How do I do this? Create table want as Select put(purchase_date format=YYMMN6., YYMMN6.) From have ;   ... View more