Altair slc language7 perl read write text files summarize and looping with sqlite
Too long to post on a list, see github
https://github.com/rogerjdeangelis/utl-altair-slc-language7-perl-read-write-text-files-summarize-and-looping-with-sqlite
CONTENTS
1 regression using sqlite table
2 summarize the table
select group_concat(name), sex, mean(age), mean(height) from have group by sex
3 write and read text files in sqlite
4 sqlite looping
find the median of numbers 1-10 (5.5)
5 sqlite tables back to slc
Note: Most of the SQLite queries below can NOT be done in 'proc sql' in sas or the slc
Note sqlite has csv read and write commands, however I want to present general txt processing in sql.
Keep in mind that I am demonstrating that the exact sqlite queries work in the 8 languages below.
In addition you can use the exact same queries in any language or operating system that supports odbc.
OBJECTIVE
I am trying to make sql programmers expert programmers in
8 languages using exactly the same sql queries.
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 powershell
RELATED REPOS (SEE FOR INFORMATION OF INSTALLING ODBC AND SQLITE
https://github.com/rogerjdeangelis/utl-altair-slc-sqlite-cheat-sheet
https://github.com/rogerjdeangelis/utl-altair-slc-language1-drop-down-to-open-source-spss-and-execute-postgresql-query
https://github.com/rogerjdeangelis/utl-altair-slc-language2-drop-down-to-open-source-matlab-and-execute-sqlite-with-extensions
https://github.com/rogerjdeangelis/utl-altair-slc-language3-proc-r-read-write-csv-files-and-summarize-and-looping-with-sqlite
https://github.com/rogerjdeangelis/utl-altair-slc-language4-proc-python-read-write-csv-files-and-summarize-and-looping-with-sqlite
https://github.com/rogerjdeangelis/utl-altair-slc-native-language5-odbc-read-write-text-files-summarize-and-looping-with-sqlite
https://github.com/rogerjdeangelis/utl-altair-slc-language6-rexcel-read-write-text-files-summarize-and-looping-with-sqlite
https://github.com/rogerjdeangelis/utl-altair-slc-language7-perl-read-write-text-files-summarize-and-looping-with-sqlite
