%let pgm=utl-calling-python-from-personal-altair-slc-and-integrating-python-with-sql;
%stop_submission;
Calling python from personal altair slc and integrating python with sql
Too long to post here, see github.
Is there a way to use import export with python?
SOAPBOX ON
I am new to the personal version of the Altair SLC, so all of this may not betrue.
I expert peer review would be nice?
CONTENTS
1 Python import export of sas datasets is blocked
2 python workaround for interfacing with base slc
python pyreadstat to read sas dataset
python json to conver panda dataframe to json file
sas json engine to read python json output
(could use csv)
Should be able to have python produce compressed json files
3 python calling sqlite (sqlite is very powerfull. I inclued window extensions)
see github file fn_pythonx.py
select sges = 14 from sd1.have
github
https://tinyurl.com/yznnxxda
https://github.com/rogerjdeangelis/utl-calling-python-from-personal-altair-slc-and-integrating-python-with-sql