Thanks, Resa!  I appreciate your input on this topic.   Here is what I had to do to get it to work:   Change my sasconfig to "winlocal" Update the path to the .jar files with my path, which was off by 1-2 characters in a folder name Add the path to the correct sspiauth.dll file to the system %PATH= Then it worked!  Much appreciated.   Patrick ... View more

Yes, thank you.  I have followed the instructions to their extent.  I have managed to install the SAS Kernel.  I believe that it is an issue of configuration, as @Resa had mentioned.  But I have not found documentation with my error. ... View more

Hi Resa, Thanks!  I think I'm getting closer.  Here's the error I'm getting now:   Java Error: java.lang.NoClassDefFoundError: com/sas/services/connection/ConnectionFactoryException at java.lang.Class.getDeclaredMethods0(Native Method) at java.lang.Class.privateGetDeclaredMethods(Unknown Source) at java.lang.Class.privateGetMethodRecursive(Unknown Source) at java.lang.Class.getMethod0(Unknown Source) at java.lang.Class.getMethod(Unknown Source) at sun.launcher.LauncherHelper.validateMainClass(Unknown Source) at sun.launcher.LauncherHelper.checkAndLoadMain(Unknown Source) Caused by: java.lang.ClassNotFoundException: com.sas.services.connection.ConnectionFactoryException at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) ... 7 more Error: A JNI error has occurred, please check your installation and try again Exception in thread "main" Subprocess failed to start. Double check you settings in sascfg.py file. Attempted to run program java with the following parameters:['java', '-classpath', 'C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94472__prt__xx__sp0__1\\deploywiz\\sas.svc.connection.jar;C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94472__prt__xx__sp0__1\\deploywiz\\log4j.jar;C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94472__prt__xx__sp0__1\\deploywiz\\sas.security.sspi.jar;C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94472__prt__xx__sp0__1\\deploywiz\\sas.core.jar;C:\\ProgramData\\Anaconda3\\Lib\\site-packages\\saspy\\java\\saspyiom.jar', 'pyiom.saspy2j', '-host', 'localhost', '-stdinport', '52898', '-stdoutport', '52899', '-stderrport', '52900', '-zero', ''] If no Java Error above, try running the following command (where saspy is running) manually to see if it's a problem starting Java: java -classpath "C:\Program Files\SASHome\SASDeploymentManager\9.4\products\deploywiz__94472__prt__xx__sp0__1\deploywiz\sas.svc.connection.jar;C:\Program Files\SASHome\SASDeploymentManager\9.4\products\deploywiz__94472__prt__xx__sp0__1\deploywiz\log4j.jar;C:\Program Files\SASHome\SASDeploymentManager\9.4\products\deploywiz__94472__prt__xx__sp0__1\deploywiz\sas.security.sspi.jar;C:\Program Files\SASHome\SASDeploymentManager\9.4\products\deploywiz__94472__prt__xx__sp0__1\deploywiz\sas.core.jar;C:\ProgramData\Anaconda3\Lib\site-packages\saspy\java\saspyiom.jar" pyiom.saspy2j -host localhost -stdinport 52898 -stdoutport 52899 -stderrport 52900 -zero 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! Out[1]: 'No SAS process attached. SAS process has terminated unexpectedly.'   Do you know if I have to run a sas process via SAS Deployment manager or some other app?  Are you running it from a server or a localhost?   ... View more

For the sake of posterity:   PROC SQL; CREATE TABLE REPORT AS SELECT 'OVERALL' AS Jurisdiction , SUM(CASE WHEN BUILDINGTYPE = 'private' THEN ENR ELSE . END)/SUM(CASE WHEN BUILDINGTYPE = 'private' AND ENR IS NOT NULL THEN 1 ELSE 0 END) As Private , SUM(CASE WHEN BUILDINGTYPE = 'public' THEN ENR ELSE . END)/SUM(CASE WHEN BUILDINGTYPE = 'public' AND ENR IS NOT NULL THEN 1 ELSE 0 END) as Public FROM HAVE UNION ALL SELECT DISTINCT 'Jurisdiction', ., . FROM HAVE UNION ALL SELECT jurisdictn , SUM(CASE WHEN BUILDINGTYPE = 'private' THEN ENR ELSE . END)/SUM(CASE WHEN BUILDINGTYPE = 'private' AND ENR IS NOT NULL THEN 1 ELSE 0 END) As Private , SUM(CASE WHEN BUILDINGTYPE = 'public' THEN ENR ELSE . END)/SUM(CASE WHEN BUILDINGTYPE = 'public' AND ENR IS NOT NULL THEN 1 ELSE 0 END) as Public FROM HAVE GROUP BY jurisdictn ; QUIT; ... View more

Plenty of ways to do this.  Here's one:   data have; infile datalines missover; informat buildingname $10. buildingtype $8. responded $1. jurisdictn $9. enr best5. ; input buildingname 1-10 buildingtype responded jurisdictn enr ; cards; happy days private Y nottingha 100 learning public N nottingha buildingbl private Y nottingha 55 montessori private N nottingha bean stalk private Y brunswick 55 learning private Y brunswick 22 early lear private Y brunswick 255 childtime private N brunswick risingstar public N brunswick doodlebugs public Y brunswick 34 ; run; proc means data=have mean; class jurisdictn buildingtype; var enr; run; proc tabulate data=have; class jurisdictn buildingtype; var enr; table jurisdictn, buildingtype * enr*mean; run; PROC SQL; CREATE TABLE REPORT AS SELECT 'OVERALL' AS Jurisdiction , SUM(CASE WHEN BUILDINGTYPE = 'private' THEN ENR END)/SUM(CASE WHEN BUILDINGTYPE = 'private' AND ENR IS NOT NULL THEN 1 ELSE 0 END) As Private , SUM(CASE WHEN BUILDINGTYPE = 'public' THEN ENR END)/SUM(CASE WHEN BUILDINGTYPE = 'public' AND ENR IS NOT NULL THEN 1 ELSE 0 END) as Public FROM HAVE UNION ALL SELECT DISTINCT 'Jurisdiction', ., . FROM HAVE UNION ALL SELECT jurisdictn , SUM(CASE WHEN BUILDINGTYPE = 'private' THEN ENR END)/SUM(CASE WHEN BUILDINGTYPE = 'private' AND ENR IS NOT NULL THEN 1 ELSE 0 END) As Private , SUM(CASE WHEN BUILDINGTYPE = 'public' THEN ENR END)/SUM(CASE WHEN BUILDINGTYPE = 'public' AND ENR IS NOT NULL THEN 1 ELSE 0 END) as Public FROM HAVE GROUP BY jurisdictn ; QUIT; ... View more

In that case, does the solution that I have above work for you? ... View more

Assuming what @ballardw is saying is true in that your purpose is to sum, and you are grouping by terr, then here is a relatively simple solution in proc sql (there are many ways do this but this is one):   data have; input dist terr relid mkt $ product $ TR NR; datalines; 101 1 210 XI_U XIA 100 0 101 2 211 XI_U XIA 0 60 101 1 212 XI_U XIA 110 70 101 1 213 XI_U XIA 112 80 101 2 214 XI_U XIA 115 91 ; PROC SQL; CREATE TABLE WANT AS SELECT TERR, SUM(TR) AS TOTAL_TR, SUM(NR) AS TOTAL_NR FROM HAVE GROUP BY TERR; QUIT; ... View more