-
Why can't I embed PROC R in a macro?
The SAS language and the R language have very different syntax and semantics so it is not possible to place R procedure calls inside SAS language macro procedures. This may appear to be a limitation but the two languages have different interpretations of special characters and keywords that would cause conflicts with SAS…
-
Where is the temporary location used by the Workflow environment of Workbench?
Temporary Disk Space for Workflow Environment On the client-side we have the "results cache" as defined in Preferences > Altair > Workflow > Temporary Resources. On the server-side we have the "intermediate files" as defined in Workflow Link Explorer > SERVERNAME > Properties. SERVERNAME may be, for example, 'Local' or…
-
Where are my workbench startup options saved?Will be replaced by the install/admin guide for 2024, or earlier.
In the workbench, STARTUP options are saved in the file <your_workspace_root>\.metadata\.plugins\com.wpc.wps\sessions.xml. For example: <?xml version="1.0" encoding="UTF-8" standalone="no"?> <serverConnections default="Local"> <serverConnection autostart="true" initialDirectory="${workspace_loc}" name="Local"…
-
When importing excel files how do I prevent truncation of columns?
Issue: When importing Excel files on Windows when the following WARNING is given "WARNING: Truncating column COMMENTS to DBMAX_TEXT(1024)". Solution: You can change the dbmax_text value using the DBLIBOPTS statement of PROC IMPORT, for example: PROC IMPORT DATAFILE="demo.xlsx" OUT=test DBMS=EXCEL2007 REPLACE;…
-
What is the minimum specification for a Altair SLC workstation?
The minimum specifications required just to run Altair SLC on a Windows machine are very modest. Less than 1G of disk space is required for the installation, and the software has been run on operating systems Windows 7 and later, so any modern PC will be perfectly adequate for most operations. We typically recommend a…
-
What is the difference between LINK and COMMUNICATE?
Altair SLC Link Altair SLC Link is a technology that essentially takes a local script or part of a local script from a local Workbench client and executes it on a remote platform. Any log files, HTML or Listing results, and any datasets created from executing the program remotely are returned to the client through the…
-
What colour names does Altair SLC support?
BLACK, 0x0, 0x0, 0x0 BL, 0x0, 0x0, 0x0 BLUE, 0x0, 0x0, 0xff B, 0x0, 0x0, 0xff BROWN, 0xa0, 0x50, 0x0 BR, 0xa0, 0x50, 0x0 CHARCOAL, 0x4f, 0x4f, 0x4f CREAM, 0xe8, 0xd8, 0x98 CYAN, 0x0, 0xff, 0xff GOLD, 0xff, 0xaa, 0x0 GRAY, 0x80, 0x80, 0x80 GREY, 0x80, 0x80, 0x80 GR, 0x80, 0x80, 0x80 A, 0x80, 0x80, 0x80 GREEN, 0x0, 0xFF, 0x0…
-
What are the license expiring rules related to the log output?
The wpskey/setinit license alert mechanisms conform to the following rules: 1. No license at all, or license cannot be found. Message to the console or standard out: This Altair SLC software is not currently licensed: please apply a license key. 2. License Working in Valid Period Normal log file output continues right up…
-
Unable to start the workbench?
In some problematic situations (e.g. if a user has ran out of disk space) then a file or files in the workspace sub-folder ".metadata" can get corrupted and Workbench may not start up correctly when you restart Altair SLC. By pointing to a different workspace this can help verify that there is something wrong with the old…
-
Trouble reading an XLSX file into Altair Analytics Workbench?
Issue Reading an Excel sheet causes the following error: NOTE: SELECT `Store`,`Year`,`Week`,`UPC`,`Description`,`Reg Retail`,`RET QTY`,`Instore RET`,`Instore Qty`,`Trimester Ret`,`Tri QTY`,`Fyler`,`Flyer Qty`,`TOTAL`,`Total Qty`,`# SAP`,`PLANO`,`CATEGORIES` FROM `STR4857$` _N_=1 _ERROR_=1 Store=. Year=. Week= UPC=.…