Altair slc language6 rexcel read write text files summarize and looping with sqlite
SOAPBOX ON
I don't think it is possible to add sheets to a CLOSED excel workbook preserving style using sas.
Alos I don't think sas can preserve the style of the workbook.
I even doublt you can do it with sas access?
r excel and python excel (with the code below) can add sheets to a CLOSED workbook
SOAPBOX OFF
Note: None of the process queries are supported by the slc 'proc sql' or sas 'proc sql'
Note: Character strings are defaulting to 1024 bytes, to fix this you need to define
the table attributes explicitly in sqlite. Macro utl_optlenpos will optimize the lengths of all variables.
Too long to post on a list, see github
https://github.com/rogerjdeangelis/utl-altair-slc-language6-rexcel-read-write-text-files-summarize-and-looping-with-sqlite
Note: 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.
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-sqliteDescription: Kindly add description here
Product/Topic Name : Kindly include the product name, version if applicable here. Also, Don't forget to tag with the product/topic related to your question.
*Note from Community Team - Once you receive a satisfactory answer on your question, kindly mark your answers as "Accepted" so it can help others with similar problems. Thanks.
