BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
as_sas
Fluorite | Level 6

Here is a output from SASPY on connect SAS IOM server,

colab.PNG

Here is the same one from viya server,

viya.PNG

My question is how can I config it so that viya out will match the other one. 

 

BTW I use all default setting in both cases.

 

Thanks in advance.

 

Thanks. 

1 ACCEPTED SOLUTION

Accepted Solutions
sastpw
SAS Employee

I do see that the way Jupyter formats html is different between Lab and Notebook. In Lab, I see the output like what you have for IOM, while in Notebook that same html renders like you have for your Viya case. Are you running these in the same Jupyter environment?

 

View solution in original post

4 REPLIES 4
sastpw
SAS Employee

I can't reproduce this, I get the same output for SAS9, Viya 3.5 and Viya 4. I even tried the 'ods' line you have in the one that's different for viya (why is that in there, and what other things have been submitted in that session?). I'm guessing you've submitted other ods statements in that session that have caused a change, but there's no telling.

sastpw
SAS Employee

I do see that the way Jupyter formats html is different between Lab and Notebook. In Lab, I see the output like what you have for IOM, while in Notebook that same html renders like you have for your Viya case. Are you running these in the same Jupyter environment?

 

as_sas
Fluorite | Level 6

I do get the same output looking in running @ jupyter-lab. It is good to know. Thanks a lot.

as_sas
Fluorite | Level 6

Are you running these in the same Jupyter environment?

 

No.

 

SASPY connecting SAS IOM server is in Google Colab and  SASPY connecting SAS viya server is in pure Jupyter Notebook. And both cases are using the default HTML ouput seetings.

 

Colab session saspy,

import saspy
sas = saspy.SASsession(java='/usr/lib/jvm/java-8-openjdk-amd64/jre/bin/java', iomhost=['odaws01-usw2.oda.sas.com',
        'odaws02-usw2.oda.sas.com','odaws03-usw2.oda.sas.com','odaws04-usw2.oda.sas.com'], iomport=8591, encoding='utf-8')
sas object seting:
Using SAS Config named: default
Please enter the IOM user id: uuu@zzz.com
Please enter the password for IOM user : ··········
SAS Connection established. Subprocess id is 268

Access Method         = IOM
SAS Config name       = default
SAS Config file       = /usr/local/lib/python3.7/dist-packages/saspy/sascfg.py
WORK Path             = /saswork/SAS_work6C890000FB0A_odaws03-usw2.oda.sas.com/SAS_work217E0000FB0A_odaws03-usw2.oda.sas.com/
SAS Version           = 9.04.01M6P11072018
SASPy Version         = 3.7.5
Teach me SAS          = False
Batch                 = False
Results               = Pandas
SAS Session Encoding  = utf-8
Python Encoding value = utf-8
SAS process Pid value = 64266
 
 
 
Viya session saspy,
import saspy
sas = saspy.SASsession(cfgname='httpsviya', encoding='utf-8')
sas
 
sas object seting:
SAS server started using Context Data Mining compute context with SESSION_ID=a038c941-6a66-4faa-9126-1cb31d2734b3-ses0000
 
Out[11]:
Access Method         = HTTP
SAS Config name       = httpsviya
SAS Config file       = /s/anaconda/users/uuu/conda3/envs/py37/lib/python3.6/site-packages/saspy/sascfg_personal.py
WORK Path             = /proj/saswork/SAS_work9F2B00016AB5_ito087408/
SAS Version           = V.03.05M0P11112019
SASPy Version         = 3.7.5
Teach me SAS          = False
Batch                 = False
Results               = Pandas
SAS Session Encoding  = utf-8
Python Encoding value = utf_8
SAS process Pid value = 92853
 
 At lease SAS versions are difference.
 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1074 views
  • 1 like
  • 2 in conversation