Personal altair slc convert sas datastep to slc sql odbc r python
PROBLEM: select first occurance by sex where the age is 14
I am new to the personal Altair slc but there appears to be a problem with odbc sqlite?
Too long to post to listserves, see githib
github
https://tinyurl.com/ybm73xfe
https://github.com/rogerjdeangelis/utl-personal-altair-slc-convert-sas-datastep-to-slc-sql-odbc-r-python
The personal Altair slc supports ODBC without an access product.
I downloaded and installed the sqlite odbc driver, but using
that driver failed. I posted the problem, hopefully we will get an solution.
Note, this may be my problem not Altairs.
github
https://tinyurl.com/5au8cwpk
https://github.com/rogerjdeangelis/utl-sqllite-odbc-driver-works-in-r-but-not-in-personal-altair-slc
stackoverflow sas
https://tinyurl.com/3vvxa5zz
https://stackoverflow.com/questions/79766528/converting-sas-data-steps-into-proc-sql-with-row-number-partition-but-altair-wor
CONTENTS
1 slc datastep
2 slc proc sql
3 slc odbc fails (may be my problem)
4 slc r sqlite
5 slc python sqlite
6 sqlpartitionx macro
(Because I use monotonic use it only as is to sequence groups
or one overall sequence Do not make it a view or add any subqueies..
If you complicate the code beyond a simple sequencing, the
sas optimizer might reorder the groups for faster performance
and the patitioning will be out of order)
