RE: Altair slc simple market basket passthru sqlite libname sqlite and proc sql
Too long to post on a list, see github
https://github.com/rogerjdeangelis/utl-altair-slc-simple-market-basket-passthru-sqlite-libname-sqlite-and-proc-sql
PROBLEM (WHAT OTHER ITEMS ARE PURCHASED WHEN PURCHASING BUTTER)
PRODUCTS CUSTOMERS
butter 545 545, out of 9,835 customers, have butter in their market basket
also purchased with butter
whole milk 271 50% half of them also purchased whole milk (271/545)
other vegetables 197 36% purchased vegetables 197/545
yogurt 144 26% purchased vegetables 144/545
rolls/buns 132 24% purchased rolls/buns 132/545
You can run the sqlite code in any of the 8 languages below.
CONTENTS
1 slc proc sql (only sas datasets)
2 slc libname sqlite
3 slc passthru sqlite
Related to Altar Post
https://community.altair.com/discussion/50697/market-basket-analysis-operators-to-change-data-layout?tab=all
PREP INSTALL ODBC DRIVER
Download Christian Werner ODBC Drive (sqliteodbc_w64)
Note some browsers will block the download as unsafe mainly because
the site is http and not https. I have tested the download for malicious software and
it is ok, however always 'create a restore point' before downloading.
http://www.ch-werner.de/sqliteodbc/
