-
RE: Altair scl Exploratory forecasting sunspot activity with auto arima time series
%let pgm=utl-altair-slc-exploratory-forcasting-sunspot-activity-with-r-auto-arima-time-series; %stop submission Altair scl Exploratory forecasting sunspot activity with auto arima time series Forecast the next 12 years of sunspots Too long to post on a list, see github…
-
RE: Generating complete case logic for decision trees using altair personal slc
Generating complete case logic for decision trees using altair personal slc Too long to post o a list, see github github https://github.com/rogerjdeangelis/utl-generating-complete-case-when-logic-for-decision-trees-using-altair-personal-slc Altair posts…
-
RE: Altair slc 2:35 minutes vs rapid miner import csv taking more than 40 minutes
Altair slc 2:35 minutes vs rapid miner import csv taking more than 40 minutes; SLC took: real time : 2:35.311 minutes Too long to post on list, see github https://github.com/rogerjdeangelis/utl-altair-slc-three-minutes-vs-rapid-miner-import-csv-taking-more-than-forty-minutes Altair Post…
-
RE: Altair slc determining type and length of excel columns before importing
Altair slc determining type and length of excel columns before importing Too long to post on a list, see github https://github.com/rogerjdeangelis/utl-altair-slc-determining-type-and-length-of-excel-columns-before-importing Altair Community…
-
Siemens interactive mouse surfing software vs altair slc code driven software, a paradigm shift
SOAPBOX ON AI AI is ushering in a new era of code-driven solutions. Non-programmers can now create functional code with ease — a transformation that will deeply impact interactive, mouse-driven software. Siemens dropping technical support for the Altair SLC will kill the SLC. No company will purchase the SLC without…
-
RE: Altair scl reading a currupted csv recovering the most good data
Altair scl reading a currupted csv recovering the most good data Too long to post on a list. see github https://github.com/rogerjdeangelis/utl-altair-scl-reading-a-currupted-csv-recovering-the-most-good-data Altair community post https://community.altair.com/discussion/52461/i-cannot-read-the-data-correctly-help?tab=all…
-
RE: Altair slc split closed workbook excel sheet into male and female sheets libname excel
Altair slc split closed workbook excel sheet into male and female sheets libname excel Problem Add sheets males and femaels using the class sheet Too long to post to list, see github https://github.com/rogerjdeangelis/utl-altair-slc-split-closed-workbook-excel-sheet-into-male-and-female-sheets-libname-excel Altair Post…
-
RE: Altair slc Synthetic Minority Oversampling smoke balance placebo and treatment
Altair slc Synthetic Minority Oversampling smoke balance placebo and treatment Problem create synthetic data to balance placebo and treatment, counts PLACEBO TREATMENT -------- --------- Before: {0.0: 352, 1.0: 36 } After: {0.0: 352, 1.0: 352} /--- was 36 added 316 ---/ Too long to post on a list, see giyhub…
-
Altair slc jacknife correctly computes standard error for complex survey designs
Altair slc jacknife correctly computes standard error for complex survey designs Too long to post on a list, see github https://github.com/rogerjdeangelis/utl-altair-slc-jacknife-correctly-computes-standard-error-for-complex-survey-designs Altair post https://community.altair.com/discussion/49468/jackknife-tests/p1?tab=all…
-
RE: Altair slc simple market basket passthru sqlite libname sqlite and proc sql
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…
-
RE: Altair slc k medoids clustering using r
Altair slc k mediods clustering using r Too long to post on a list,see github https://github.com/rogerjdeangelis/utl-altair-slc-k-mediods-clustering-using-r Graphic output The graph uses factor analysis to reduce the dimensionality for visualization of four dimesional space.…
-
RE: Altair slc som clustering SOM Dimensionality Reduction using r and python
RE: Altair slc som clustering SOM Dimensionality Reduction using r and python Way beyond my comfort zone. Could not get R and Python to agree? Graphic output https://github.com/rogerjdeangelis/utl-altair-slc-som-clustering-SOM-Dimensionality-Reduction-using-r-and-python/blob/main/iris_som_codes.png…
-
RE: Altair slc probabilistic neural networks pnn gaussain kernel using r
RE: Altair slc probabilistic neural networks pnn gaussain kernel using r Too long to post on a list, see github https://github.com/rogerjdeangelis/utl-altair-slc-probabilistic-neural-networks-pnn-gaussain-kernel-using-r community post https://community.altair.com/discussion/58644/pnn-implementation?tab=accepted Confirms…
-
Altair slc language8 powershell read write text files summarize and looping with sqlite
Altair slc language8 powershell 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-language8-powershell-read-write-text-files-summarize-and-looping-with-sqlite CONTENTS 1 regression using sqlite table 2 summarize slite table…
-
Altair SLC doesn't support the _ALL_ syntax for proc contents for ODBC-connected databases.
Unlike SAS, Altair SLC doesn't support the ALL syntax for proc contents for ODBC-connected databases. Note 'proc contents' works with [libname].table but fails with [libname].all, see below 1 libname sqlite odbc noprompt=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX; NOTE: Library…
-
Altair slc language7 perl read write text files summarize and looping with sqlite
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…
-
Altair slc language6 rexcel read write text files summarize and looping with sqlite
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…
-
Question on Altair SLC Personal Edition – 2025 vs 2026 Licensing Behavior
Hello, I would like to clarify the current availability of the Altair SLC Personal Edition. At the moment, I have downloaded and tested the SLC 2025 engine installer, which appears to allow local usage without requiring Altair Managed Licensing (ALM), effectively behaving like a Personal Edition. However, when testing the…
-
Altair slc native language5 odbc read write text files, summarize and looping with sqlite
Altair slc native language5 odbc read write text files, summarize and looping with sqlite 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…
-
Altair slc language4 proc python read write text files summarize and looping with sqlite
Altair slc language4 proc python read write text files summarize and looping with sqlite Too long to post on a list, see gethub https://github.com/rogerjdeangelis/utl-altair-slc-language4-proc-python-read-write-csv-files-and-summarize-and-looping-with-sqlite Note: Note sqlite has csv read and write commands, however I want…
-
Altair slc language3 proc r read write csv files and summarize and looping with sqlite
Altair slc language3 proc r read write csv files and summarize and looping with sqlite Note: SQLite has CSV read and write commands; however, I want to handle general text file processing in SQL. Keep in mind that I am demonstrating the exact sqlite queries in 9 languages below. In addition, you can use the exact same…
-
Altair slc sqlite cheat sheet
Altair slc sqlite cheat sheet Too long to post on a list see github https://github.com/rogerjdeangelis/utl-altair-slc-sqlite-cheat-sheet COMPLETE SQLITE CHEAT SHEET (WITH EXTENSIONS ON END)
-
Altair slc language2 drop down to open source matlab and execute sqlite with extensions
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…
-
Altair slc language1 drop down to open source spss and execute postgresql query
Altair slc language1 drop down to open source spss and execute postgresql query Too long to post on a list, see github https://github.com/rogerjdeangelis/utl-altair-slc-language1-drop-down-to-open-source-spss-and-execute-postgresql-query SOAPBOX ON Unlike the linux version of open source spss(pspp), odbc and native…
-
RE: Altair slc supplementing rapid miner with genetic modeling using r and python
RE: Altair slc supplementing rapid miner with genetic modeling using r and python Too long to post on a list, see github https://github.com/rogerjdeangelis/utl-altair-slc-supplementing-rapid-miner-with-genetic-modeling-using-r-and-python graphics…
