Hello,   This is regarding SAS Notebook, which is not working in Jupyter Lab.   I have installed Anaconda distribution of Python as well as Jupyter Lab and modified the saspy configuration file.  The path to sspiauth.dll has also been added to the system PATH variable. SASPy is working fine. In the Jupyter Lab platform, I have been able to lunch python notebook, running python code, SASPy, and %%SAS and SAS code using Python kernel.   Issue: When attempting to launch SAS notebook (using licensed SAS 9.4M6, not the University edition), I get a dead kernel (i.e., No Kernel).  When the SAS kernel is selected, I get the following error message.   Error Starting Kernel Traceback (most recent call last):   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\site-packages\tornado\web.py", line 1699, in _execute     result = await result   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\site-packages\tornado\gen.py", line 736, in run     yielded = self.gen.throw(*exc_info)  # type: ignore   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\site-packages\notebook\services\sessions\handlers.py", line 73, in post     type=mtype))   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\site-packages\tornado\gen.py", line 729, in run     value = future.result()   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\site-packages\tornado\gen.py", line 736, in run     yielded = self.gen.throw(*exc_info)  # type: ignore   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\site-packages\notebook\services\sessions\sessionmanager.py", line 79, in create_session     kernel_id = yield self.start_kernel_for_session(session_id, path, name, type, kernel_name)   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\site-packages\tornado\gen.py", line 729, in run     value = future.result()   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\site-packages\tornado\gen.py", line 736, in run     yielded = self.gen.throw(*exc_info)  # type: ignore   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\site-packages\notebook\services\sessions\sessionmanager.py", line 92, in start_kernel_for_session     self.kernel_manager.start_kernel(path=kernel_path, kernel_name=kernel_name)   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\site-packages\tornado\gen.py", line 729, in run     value = future.result()   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\site-packages\tornado\gen.py", line 209, in wrapper     yielded = next(result)   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\site-packages\notebook\services\kernels\kernelmanager.py", line 160, in start_kernel     super(MappingKernelManager, self).start_kernel(**kwargs)   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\site-packages\jupyter_client\multikernelmanager.py", line 110, in start_kernel     km.start_kernel(**kwargs)   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\site-packages\jupyter_client\manager.py", line 259, in start_kernel     **kw)   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\site-packages\jupyter_client\manager.py", line 204, in _launch_kernel     return launch_kernel(kernel_cmd, **kw)   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\site-packages\jupyter_client\launcher.py", line 138, in launch_kernel     proc = Popen(cmd, **kwargs)   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\subprocess.py", line 775, in __init__     restore_signals, start_new_session)   File "C:\Users\Pradip.Muhuri\AppData\Local\Continuum\anaconda3\lib\subprocess.py", line 1178, in _execute_child     startupinfo) FileNotFoundError: [WinError 2] The system cannot find the file specified           Below is the output from the kernelspc list command.   base) C:\Users\FN.LN>jupyter kernelspec list Available kernels:   ir         C:\Users\FN.LN\AppData\Roaming\jupyter\kernels\ir   python3    C:\Users\FN.LN\AppData\Roaming\jupyter\kernels\python3   sas        C:\Users\FN.LNi\AppData\Roaming\jupyter\kernels\sas     #Check whether the pyiom directory has the files saspy2j.class and saspy2j.java inside itimport os# List all files in a directory using os.listdirmypath = '/Users/FN.LN/AppData/Local/Continuum/anaconda3/lib/site-packages/saspy/java/pyiom'for entry in os.listdir(mypath😞    if os.path.isfile(os.path.join(mypath, entry)):        print(entry) saspy2j.classsaspy2j.java   I would appreciated if you could help me by resolving the  ‘No Kernel’ issue when the SAS kernel is selected from Jupyter Lab .   Thanks, ... View more

@Autotelic wrote: Even though I don't understand it, it works. I thought the second parameter in the put() function should be how one wants to read the first parameter, but the first parameter is Date9., so, in my mind, trying to read Date9. as YYMMN6. should yield a missing value. You're confusing the put() and the input() function. input() reads, while put() displays. Therefore you also need display formats for put(), but informats for input(). In your case, the date value in the original variable purchase_date is "displayed" in the yymmn6. format, and the resulting character string stored in the new variable which is also named purchase_date. ... View more

Unfortunately, no there isn't a way to suppress the message. Because we are changing your data, we want to make sure that you are aware that it has been done and so we always produce that message. The only thing I could suggest would be using Notepad++ to search for the character in your data file and change it to a space before trying to import it in with EG. ... View more

Because of what I said earlier.    SAS stores datetime as numbers, where it is the number of seconds from Jan 1, 1960   If your variable is a number that reflects a date but not something SAS can work from as a date. For example you can subtract SAS dates to determine the number of days between two dates. Numbers stored in the format you've shown will not allow for that type of calculation.    The PM part comes from the format you apply to the data.   data have; mydate = "20171003155533"; mydate_num = input(mydate, best32.); mydate_sas = input(mydate, B8601DJ.); format mydate_num mydate_sas datetime.; run; proc print;run;           ... View more

@Autotelic wrote: Can you tell me where to read about your solution ":". I can't find it at http://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=n0oaql83drile0n141pdacojq97s.htm&docsetVersion=9.4&locale=pt It's part of list input: http://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=n0lrz3gb7m9e4rn137op544ddg0v.htm&docsetVersion=9.4&locale=de ... View more

@Autotelic wrote: I'm on SAS 9.2 (I just added this information to the post). I assume this is why I do a manual import, it converts to csv first. I routinely convert Excel files to CSV prior to reading them with a data step because proc import has to guess about variable types and lengths. In most cases repeated files of supposedly the same the layout and similar content will get changes in lengths of character variables or types of variables when using import causing headaches when combining the data. I head that off by the data step reading a known structure and setting the variable types and lenghths based on the agreed description of the data I should be getting.     ... View more