-
Personal SLC Template for ODBC and DB engines to access large # of databases direct with SLC code an
Altair personal slc postgresql select the first ob in each group ordered by specific variables Too long to post on a listserve, see github github https://github.com/rogerjdeangelis/utl-altair-personal-slc-postgresql-passthru-select-first-ob-by-group-ordered-by-specific-variables SAMPLE ODBC…
-
Altair personal slc odbc sqlite read write access meta data
Altair personal slc odbc sqlite read write access meta data see github, too long to post on a listserv https://github.com/rogerjdeangelis/utl-altair-personal-slc-odbc-sqlite-read-write-access-meta-data CONTENTS (Altair Personal SLC and sqlite - no access product needed) 1 creating sqlite table classage 2 print sqlite table…
-
Help conneting to postgresql database using Altair Personal SLC
Help to connect to postgresql database I created a table in postgresql using the built-in superuser postgres Install postgresql https://www.postgresql.org/download/windows/ /-- add a table in template1 for testing ----/ cmd.exe C:\WINDOWS\system32>psql -U postgres -d template1 Password for user postgres: xxxxxxxxxxx…
-
Altair personal slc disabling precode html destination and adding help datasets metadata
Altair personal SLC disabling precode html destination and adding help datasets & metadata; CONTENTS ( I found it difficult to turn off the precoded html destination) 0 slc html & listing; 1 slc only listing 2 slc streamlining disabling precode 3 slc acessing help and user datasets and dictionaries librefs )in autoxec)…
-
Altair Monarch and personal altair slc compute business days between two dates
Altair Monarch and personal altair slc compute business days between two dates Too long to post on a listserv, see github github https://github.com/rogerjdeangelis/utl-post-weekend-and-holiday-sales-to-the-next-business-weekday-using-personal-altair-slc TWO SOLUTIONS 1 personal slc 2 monarch (see link) community.altair…
-
Personal altair slc convert sas datastep to slc sql odbc r python
Personal altair slc convert sas datastep to slc sql odbc r python PROBLEM: select first occurance by sex where the age is 14 I am new to the personal Altair slc but there appears to be a problem with odbc sqlite? Too long to post to listserves, see githib github…
-
Sqllite odbc driver works in r but not in personal altair slc
SQLite ODBC driver works in r but not in Personal Altair slc There are no database passwords in this post I did not reboot or exit the SLC and restart, because R worked? Too long to pot in a listserv, see GitHub. github https://tinyurl.com/5au8cwpk…
-
Turning off the splash screen in the personal Altair SLC eclipse
Turning off the splash screen in the personal Altair SLC eclipse According to the documentation? Adding -nosplash C:\Program Files\Altair\Analytics Workbench\2025\eclipse\workbench.ini -startup -nosplash Is supposed to eliminate the annoying splash screen, but it does not. Roger
-
Annotate points on a map using the personal edition of the altair slc
Annotate points on a map using the personal edition of the altair slc see github (does not fit in the styling of Altair Community List) High res graphic https://tinyurl.com/ym56k8u7 https://github.com/rogerjdeangelis/utl-annotate-points-on-a-map-using-the-personal-edition-of-the-altair-slc/blob/main/slov_map.pdf github…
-
Psuedo batch personal altair slc and calling slc from python and r
Psuedo batch personal Altair SLC and calling SLC from Python and R see GitHub https://tinyurl.com/3sy3sh5z https://github.com/rogerjdeangelis/utl-psuedo-batch-personal-altair-slc-and-calling-slc-from-python-and-r
-
Directing-output-to-a-listing-window-when-using-the-personal-altair-slc
Directing-output-to-a-listing-window-when-using-the-personal-altair-slc Too long to post here, see github github https://tinyurl.com/bddx38kc https://github.com/rogerjdeangelis/utl-directing-output-to-a-listing-window-when-using-the-personal-altair-slc- CONTENTS 1 hardcoding 2 using _init_ macro variable community.altair…
-
Altair personal slc reading and writing OpenDocument spreadsheets using r and python
Altair personal slc reading and writing OpenDocument spreadsheets using r and python Too long to post here, see github CONTENTS 1 r create and opendocument spreadsheet 2 r opendocument spreadsheet subset for males spreadsheet 3 python read OpenDocument 4 python write OpenDocument spreadsheet github…
-
Personal altair slc with matlab sympy and r finite element cold plate heat transfer
Personal altair slc with matlab sympy and r finite element cold plate heat transfer Too log to post here, see github see github https://tinyurl.com/3f9w97t2 https://github.com/rogerjdeangelis/utl-personal-altair-slc-with-matlab-sympy-and-r-finite-element-cold-plate-heat-transfer OUT OF MY COMFORT ZONE<, BUT PERHAPS SOME OS…
-
Create a sas dataset from python oanda dataframe using the personal altair slc
Create a sas dataset from python oanda dataframe using the personal altair slc Too long to post here, see github github https://tinyurl.com/5n7jw3hh https://github.com/rogerjdeangelis/utl-how-to-create-a-sas-dataset-from-python-panda-dataframe-using-the-personal-altair-slc SOAPBOX ON I am new to the Altair SLC Altair SLC,…
-
Using Altair SLC to fill gaps in proc sql select third place in the daily double r python solutions
Too long to post here, see github Problem: Pick the horse that comes in third in the daily double horse race The daily double is usaully the first and second race SELECT THIRD PLACE FOR HORSES IN THE DAILY DOUBLE SORTED FOR DOCUMENTATION ONLY. PRE SORTING IS NOT NEEDED. RACE HORSE TIME Partition 1 lady_Joyce 70.5 1 1…
-
Calling r from personal altair slc and integrating r with sql
Calling r from personal altair slc and integrating r with sql Too long to post here, see github SOAPBOX ON I am new to the personal version of the Altair SLC, so all of this may not betrue. I expert peer review would be nice? CONTENTS 1 r import export of sas datasets works 2 r calling sqlite (sqlite is very powerfull. I…
-
Calling python from personal altair slc and integrating python with sql
%let pgm=utl-calling-python-from-personal-altair-slc-and-integrating-python-with-sql; %stop_submission; Calling python from personal altair slc and integrating python with sql Too long to post here, see github. Is there a way to use import export with python? SOAPBOX ON I am new to the personal version of the Altair SLC,…
-
personal Altair SLC supports import export in R but not Python
personal Altair SLC supports import export in R but not Python Odd personal Altair SLC supports import export in R but not Python PYTHON &init; options set=PYTHONHOME "D:\python310"; PROC PYTHON; EXPORT DATA=sd1.have PYTHON=df; SUBMIT; df.info() dfo=df ENDSUBMIT; IMPORT DATA=sd1.dfo PYTHON=dfo; run;quit; ERROR 2025-09-23…
-
Need help verifying my observations on Altair personal edition SLC and eclipse
SOAPBOX ON I am not sure all of this is correct. I am novice with the personal Altair SLC. SOME LIMITATION ON ECLIPSE PROBLEMS WITH ECLIPSE Eclipse does not support saving the layout of program, log and output with dynamic updating. Saving the layout as a perspective(epf file) does not save all three windows. In other…
-
Please can PROC KCLUS be added to Altair SLC?
PROC KCLUS. How do you estimate the number of clusters in a dataset? In SAS, it's as easy as ABC. The classic way of identifying clusters is to use the elbow method: plot the within-cluster sum of squares (WCSS), then identify the "elbow" where the rate of decrease in WCSS slows down. With PROC KCLUS, you can use the ABC…
-
Need help verifying my attempts to set up Altair slc eclipse for the personal edition
Setup personal edition altair slc eclipse workspace config sasautos sasuser saswork autoexec Too long to post here, see github https://github.com/rogerjdeangelis github https://tinyurl.com/5c7kspet…
-
Setting up an alternate configuration file for the personal edition of the altair SLC
I have created a config file in a location that the personal edition, 2025.0, of the Altair SLC should use, see below C:\Users\roger\Documents\My WPS Files\altairslc_local.cfg -WORK 'd:\wpswrk' -set SASAUTOS ('!wpshome\sasmacro' 'c:/wpsoto') -SASAUTOS (SASAUTOS) -SASUSER 'd:/wpsusr' Also tried setting an environment…
-
Altair SLC does not yet allow PROC IML; SUBMIT / PYTHON; ... ENDSUBMIT; QUIT;
Currently SLC is copying SAS Software by emulating PROC IML; SUBMIT / R; ... ENDSUBMIT; QUIT; However, SLC has equivalent functionality for Python, but does not yet allow PROC IML; SUBMIT / PYTHON; ... ENDSUBMIT; QUIT;, probably because SAS Software does not include it. Can this functionality be added to SLC?
-
When will bug with proc optimalbin be fixed
Some time ago I raised a support ticket Case CS0718039 proc optimalbin not returning woe value for one bin. It was reported as fixed "following 'Maintenance' revisions have also been tested with your example 5.23.11.0.1026, 5.24.4.0.1671 and 5.25.1.0.1455 and will continue into future versions of SLC". I currently use SLC…
-
Altair SLC GROOVY procedure
From the 2026.0 release of Altair SLC, you can run code written in the Apache Groovy language in SAS language programs using the GROOVY procedure. Using scripts in the Groovy language makes it possible to take advantage of existing Java classes called from the Groovy scripts. The procedure allows to embed a script verbatim…
