-
Community Champion of the Month - October, 2025
The Community Team would like to introduce the October Champion of the Month, Roger DeAngelis @Roger DeAngelis_21630. Roger’s path began in the early 1960s, when he bought his first ebony-and-ivory K & E slide rule. In high school, he was drawn to math, physics, and Newton’s laws of motion. He attended the University of…
-
RE: Running your matlab script in the altair slc motion-damped spr
RE: Running your matlab script in the altair slc motion-damped spring Too long to post in listserv, see github github https://github.com/rogerjdeangelis/utl-running-your-matlab-script-in-the-altair-slc-motion-damped-spring Graphical soluton from matlab for motion of a dampled sprint a damped spring.…
-
Altar slc match your treatment group characteristics to your control group using propensity scoring
Altar slc match your treatment group characteristics to your control group using propensity scoring Too long to post here github https://github.com/rogerjdeangelis/altar-slc-match-your-treatment-group-characteristics-to-your-control-group-using-propensity-scoring This solution uses the 'persistent work library' defined in…
-
Altair slc enhanced autoexec file and ultraedit insert text
Altair slc enhanced autoexec file and ultraedit insert text; Too long to post here, see github github https://github.com/rogerjdeangelis/utl-altair-slc-enhanced-autoexec-file-and-ultraedit-insert-text CONTENTS 1 ENHANCED AUTOEXEC (file in this repo) Added pesistent work library, so tables can persist between ultraedit…
-
A better proc r using altair slc a macro sandwich interface with any app that supports a cli
A better proc r using altair slc a macro sandwich interface with any app that supports a cli Too long to post to a listserv, see github github This is a additional less flexible implementation then the previous macro wrapper solution.…
-
A better proc r using altair slc macro to interface with any app that supports a CLI
A better proc r using altair slc macro to interface with any app that supports a CLI Too long to post here, see github github https://github.com/rogerjdeangelis/utl-a-better-proc-r-using-altair-slc-macro-to-interface-with-any-app-that-supports-a-cli NOTE: macro utl_slc_r64 is avaiable in this repository and in…
-
RE: Altair slc adding a sheet to a xlsm workbook
RE: Altair slc adding a sheet to a xlsm workbook The posted response stated that Monarch does not support exports to a macro-enabled workbook; Too long to post in listserv, see github gihub https://github.com/rogerjdeangelis/utl-altair-slc-adding-a-sheet-to-a-xlsm-workbook community.altair.com…
-
RE: Create files with a suffix of todays date plus one while running my application
RE: Create files with a suffix of todays date plus one while running my application Too long to pst in listserv, see github gihub https://github.com/rogerjdeangelis/utl-create-files-with-a-suffix-of-todays-date-plus-one-while-running-my-application community.altair.com https://community.altair.com/discussion/5031?tab=all
-
RE: Altair slc creating a fixed length file from slc wpd table
RE: Altair slc creating a fixed length file from slc wpd table Too long to post in listserv, see github github https://github.com/rogerjdeangelis/utl-altair-slc-creating-a-fixed-length-file-from-slc-wpd-table community.altair.com https://community.altair.com/discussion/19487?tab=accepted Macro flatfile in (and in this…
-
Integrated authentication using Kerberos to SQL Server on Linux
If you would like to connect to an SQL server using Kerberos authentication, for example you are a user on a shared domain. You can connect through a DSN using an ODBC driver and a Kerberos ticket. To do this: Before you begin: Ensure that a separate machine known to your domain contains a working Kerberos Key Distribution…
-
Two critical SAS functions not available in the Altair SLC
Two critical missing sas functions in the altair slc 1 parmcards4 (sas has it) 2 sql partitioning and windows extensions using sqlite in memory database (sas viya has them) 1 PARMCARDS4 FAILS Without parmcards4 simple integration to other languages, like 'proc python' and 'proc r', is not possible. Ie cannot integrate…
-
SLC hub not enabled after issuing "wps -personal" or "wps"
Issuing either "wps -personal" or "wps" is not enabling the SLC server to run/ become active, after workbench is activated/run. Appreciate your feedback on how to have the SLC server running?
-
I seem not to be able to activate SLC:
After issuing the command: wps -personal and starting the Altair Workbench, I am unable to run applications. Below is the output of the command "wps -personal" Altair SLC Command Line Interface Version 2025 (5.25.1.0.1401-GA-release) Thereafter, some comments/options were displayed. Can someone help with this? Any…
-
RE: Altair slc appending mutiple excel ranges within one sheet
RE: Altair slc appending mutiple excel ranges within one sheet Too long to pst on listserv, see github https://github.com/rogerjdeangelis/utl-altair-slc-appending-mutiple-excel-ranges-within-one-sheet /community.altair.com https://community.altair.com/discussion/5965?tab=accepted OPS PROBLEM I need to capture the data for…
-
RE: Altair slc separate invoices for a mailing list and adressing tools
RE: Altair slc separate invoices for a mailing list and adressing tools Too long to post in a listserv, see github for complete solution github https://github.com/rogerjdeangelis/utl-altair-slc-separate-invoices-for-a-mailing-list-and-adressing-tools CONTENTS 1 Split invoices into separate files 2 Tools for mailing lists…
-
RE: Altair slc summarizing excel bank statements
RE: Altair slc summarizing excel bank statements Too long to post on listserve, see github for full solution github https://github.com/rogerjdeangelis/utl-altair-slc-summarizing-excel-bank-statements community.altair.com https://community.altair.com/discussion/19740 PROBLEM select bank statement group by: bank, type,…
-
Handbook: Altair SLC configuration and UltraEdit setup
I put together a handbook for the SLC and UntraEdit Handbook: Altair SLC configuration and UltraEdit setup Too long to post here, see github github https://github.com/rogerjdeangelis/utl-altair-slc-configuration-and-ultraedit-setup ALTAIR CONFIGURATIONS SLC & ULTRAEDIT Prepared by: Roger DeAngelis System: Windows 11 64-bit…
-
RE: Altair slc convert pdf tables to excel sheets
RE: Altair slc convert pdf tables to excel sheets Too long to post here, see github github https://github.com/rogerjdeangelis/utl-altair-slc-convert-pdf-tables-to-excel-sheets community.altair https://community.altair.com/discussion/19154?tab=all This solution requires macros array and do_over see macros…
-
I have had a Demo Licence for Altair SLC, but how do I revert to a Personal Edition licence?
I have had a Demo Licence for Altair SLC, but how do I revert to a Personal Edition licence? I am using Windows 11.
-
RE: Altair slc comparing two excel workbook sheets
RE: Altair slc comparing two excel workbook sheets Too long to post here, see github github https://github.com/rogerjdeangelis/utl-altair-personal-slc-comparing-two-excel-workbook-sheets community.altair https://community.altair.com/discussion/24939
-
RE: Altair-SLC-Monarch-Exercise-3-Composers-Analysis
RE: Altair-SLC-Monarch-Exercise-3-Composers-Analysis Too long to post here, see github github https://github.com/rogerjdeangelis/utl-altair-slc-monarch-exercise3-composers-analysis community.altai https://community.altair.com/discussion/38746 This programming wqas done without the eclipse IDE. Some programmers feel a…
-
Altair SLC UltraEdit a better IDE than eclipse maybe
Altair slc ultraedit a better IDE than eclipse maybe I think you can do all of this with open source notepad++ but i think it involves stitching together three notepad++ sessions? Too long to post on listserv, see github github https://github.com/rogerjdeangelis/utl-altair-slc-ultraedit-a-better-IDE-than-eclipse-maybe This…
-
RE: Adding 1 month to a date
RE: Adding 1 month to a date https://community.altair.com/discussion/19909?tab=all This gets very messy because adding a month to 2025-01-31, yeilds the invalid date of 2025-02-31. You would have to handle all transitions from longer months to shorter months. However you can easily go to the first day of the next month,…
-
RE: Altair personal slc parsing colon separated words in a complex real estate report
RE: Altair personal slc parsing colon separated words in a complex real estate report Too long to post in listserv, see github github https://github.com/rogerjdeangelis/utl-altair-personal-slc-parsing-colon-separated-words-in-a-complex-realestate-report community.altair https://community.altair.com/discussion/39103 macros…
-
RE: Altair personal slc add an excel columm date containing the last day of the previous month
RE: Altair personal slc add a columm called date containing the last day of the previous month Too long to post in listserv, see github github https://github.com/rogerjdeangelis/utl-altair-personal-slc-add-a-columm-called-date-containing-the-last-day-of-the-previous-month I received an excel workbook today, 2025-11-01, and…
-
RE: Altair personal slc analysis of fdic failed bamk list using excel database
RE: Altair personal slc analysis of fdic failed bamk list using excel database community.altair.com https://community.altair.com/discussion/39058 1 Create table work.banks table libname xls excel "d:/xls/FDIC Failed Bank List.xlsx"; data banks; set xls.'FDIC Failed Bank List$'n; run;quit; libname xls clear; 2 Which year…
