Workaround for the Altair Personal slc SQLite pass thru and Python bugs
Too long to post here, see github
github
https://github.com/rogerjdeangelis/utl-workaround-for-the-altair-personal-slc-sqlite-passthru-and-python-bugs
I am new to the Altair SLC, but these are my observations. I have raised these issues before
and there have been no solutions that worked.
PROBLEM
Sum the three largest YOY growth by company using sqlite partitioning using r python excel
Proc sql does not support SQLite partitioning and associated Windows extensions.
SOLUTIONS
1 proc r (workaround for missing pass thru support for sqlite)
2 proc python (workaround for import/export)
The slc does not support import/export with current Python versions.
Workaround is to use pyreadstat and pyreader to create transport R rds file and
then use proc r to export rds file as sas dataset,
I tried to downgrading numpy to fix, but the downgraded numpy failed with the
more current python version.
3 excel
Add sheet want to input Excel workbook with the solution
4 SQLite Windows extensions
