The SAS Kernel for Jupyter Notebooks is capable of running SAS programs from within the Jupyter interface.
The SAS kernel allows a user to leverage all of the SAS products they have licensed.
After installing the SAS kernel, you can use a notebook and a SAS installation to write, document, and submit SAS programming statements. The Jupyter notebook interface allows sharing of results through JSON and the SAS kernel is no exception, you can share code and results in a static form through the Jupyter notebook.
Python3 (this is now the default since Python2 went end of life in January 2020)
Jupyter version 4 or higher
SAS 9.4 or higher -- This includes SAS Viya. The SAS kernel is compatable with any version of SAS released since July 2013.
SASPy -- The SAS kernel has as dependency on SASPy. The package will be installed automatically but it must be configured to access your availble SAS server. SASPy must be configured before the SAS kernel can work successfully.
Installation
This will install the SAS Kernel for jupyter as well as the Jupyter lab extensions (jupyterlab v3+ is required) to make you a more productive programmer within Jupyter. Here are details about the extensions.
pip install SAS-kernel['jlab_ext']
The common methods to install are
pip -- PIP is the most common way to install the latest stable version of the code.
pip install sas_kernel
conda -- A conda package is also available if you prefer to use conda as your package manger
conda install -c anaconda sas_kernel
From source -- If you need to install from the source branch before a new version has been built and pushed you can install from source like this:
Note that the default branch is now main to match the GitHub convention. You can modify the about URL if you're installing from a fork or a non-default branch.
To verify that the sas_kernel is installed
jupyter kernelspec list
You should see output similar to code below:
Available kernels:
python3 /home/sas/anaconda3/lib/python3.5/site-packages/ipykernel/resources
sas /home/sas/.local/share/jupyter/kernels/sas
NOTE: You will not be able to execute SAS code through Juypter until you have configured SASPy.
Getting Started
Here is a basic example of programming with SAS and Jupyter Notebook: Getting Started
Improving Usability
For the Jupyter Lab extensions
There is a seperate reposity where the extensions are developed and maintained. See that repo for details
For the Legacy Jupyter Notebook
There are a few NBExtensions that have been created to make working with Jupyter notebooks more productive. These are largely the result of pain points from my use of SAS Kernel for programming tasks. The extensions can be found here. The list includes:
SAS Log -- which show the SAS log for the last executed cell or the entire log since the last (re)start of the notebook
themes -- this allows you to change the color scheme for your code to match the traditional SAS color scheme
NOTE: These extensions are for Jupyter Notebook they are not compatable with Jupyter Lab. Jupyter Lab extensions are in development and will be released shortly.
Installing the SAS Extensions
Details for installing the extensions for SAS can be found here
Jupyter Magics for the sas_kernel
There are magics that have been written specifically for the sas_kernel to get more details see the README
NBGrader
nbgrader is a system for assigning and grading notebooks and extends jupyter. NBgrader is compatible with the SAS kernel. The work was merged in September 2020. It will be widely available with the next release of NBGrader (0.62), until then you can install from source.
FAQ
Is there a SAS Magic that I can access from a python kernel?
Yes! There are actually several cell magics available from SAS.
They are %%SAS, %%IML, and %%OPTMODEL. To load these magics in your notebook, execute the following command %load_ext saspy.sas_magic. You can check that the magics have are successfully activated by looking at the results of %lsmagic and looking in the cell magic section.
If you use multiple SAS Cell magics in the same notebook they will share a SAS session (have the same WORK libname and MACROS). There is currently no sharing of SAS Sessions between different notebooks.
Do I need to buy SAS to use this kernel?
The SAS Kernel is simply a gateway for Jupyter notebooks to talk to SAS, as such, if SAS is not installed this kernel won't be helpful. For information on purchasing SAS click here
How does Jupyter communicate with SAS?
Behind a Jupyter notebook is a python session, that python session submits code to SAS and receives responses through various pathways (depending on the SASPy configuration). Jupyter can communicate with any SAS host (Windows, Linux, Unix, MVS) that has been released since July 2013 to present.
How can I see my SAS log, I only see the listing output?
SAS is different from many other programming languages in that it has two useful information streams, the log (which details the technical details of what happened and how long it took) and the lst (which includes the tables and graphics from the analysis). The SAS Kernel attempts to show you I think you want. Here are the rules:
LOG
LST
DISPLAYED
NOTES
Yes
No
LOG
This happens when you run DATA Step or a PROC with the noprint option
Yes
Yes
LST
---
Yes (with ERROR message(s))
Yes
ERROR messages with context from the log, then the listing output
---
Yes (with ERROR message(s))
No
LOG
---
If you want to see the log but it was not displayed you can use SASLog NBExtension which will show the log for the last executed cell or the entire log since the last (re)start of the notebook
Will this leave a bunch of SAS sessions hanging around?
A SAS session is started for each notebook you have open i.e. 5 notebooks open = 5 SAS sessions. Those sessions will remain active for the life of the notebook. If you shutdown your notebook, the SAS session will also terminate. In Jupyterhub, there are configuration options to shutdown inactive sessions and the SAS kernel complies with those directives.
I restarted my SAS Kernel and now my WORK library is now empty. What happened?
When you restart the kernel in a notebook you are terminating the current SAS session and starting a new one. All of the temporary artifacts, data sets in the WORK library, assigned libnames, filename, WORK macros, and so on are destroyed.
Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at LICENSE.txt
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.
请发表评论