Altair slc language2 drop down to open source matlab and execute sqlite with extensions
Too long to post on a list, see github
https://github.com/rogerjdeangelis/utl-altair-slc-language2-drop-down-to-open-source-matlab-and-execute-sqlite-with-extensions
PROBLEM
PROCESS
1 SLC Create sqlite database
2 SLC Create sqlite table class
3 Matlab summarize sqlite class table
select sex avg(ag) avg(height) avg(weight) from class group by sex
4 Matlab convert sqlite table to matlab matrix numbers
5 Matlab create a sqlite table with the summarized data
6 SLC read and convert the sqlite class table to a sas dataset
OBJECTIVE
I am trying to make sql programmers expert matlab programmers, by way of sqlite.
Use packages and procedures for analysis and sql for data wrangling and interfacing.
Add very powerfull sql processing to the open source spss
Posgresql has windows extensions.
I hope to add repos with drop downs to sql with windows extensions in many languages
*language 1 open source spss
*language 2 open source matlab
language 3 r
language 4 python
language 5 altair odbc sqlite
language 6 excel
language 7 perl
language 8 slc proc sql (the only solution that does not support windows extensions)
language 9 powershell
