Personal SLC Template for ODBC and DB engines to access large # of databases direct with SLC code an

Roger DeAngelis_21630

Altair personal slc postgresql select the first ob in each group ordered by specific variables

Too long to post on a listserve, see github

github
https://github.com/rogerjdeangelis/utl-altair-personal-slc-postgresql-passthru-select-first-ob-by-group-ordered-by-specific-variables

SAMPLE ODBC
https://github.com/rogerjdeangelis/utl-altair-personal-slc-odbc-sqlite-read-write-access-meta-data

Atemplate for

THREE SOLUTION


     1 personal postgresql slc passthru

     2 r sqlite

     3 python sqlite

ANY DATABASE WITH AN ODBC DRIVER

SLC ENGINES

ACCESS
DB2
EXCEL
XLSX
HADOOP
INFORMIX
MariaDB
MySQL
NETEZZA
ODBC
OLEDB
Oracle
POSTGRESQL
SAPHANA
SNOWFLAKE
SQLSERVER
Sybase
Sybase IQ
TERADATA

communities.sas
https://communities.sas.com/t5/SAS-Programming/How-to-select-the-first-observation-in-each-group-ordered-by/m-p/702524#M215179