A space for data analytics & AI related technical resources and discussions.
The ANYDT… informats are influenced by the DATESTYLE system option which in turn is influenced by the LOCALE setting. If your LOCALE setting is ENGLISH_UNITEDSTATES then the DATESTYLE system options is set to MDY. If ambiguous dates are found such as 12/03 then 03DEC will be returned when you may be expecting 12MAR. The…
Download an Oracle client/driver that is compatible with your version of the Oracle database. For example Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64) is found on http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html. After unzipping, double…
If there is no style information applied to an ODS HTML statement then the style.default will be applied. If you define a style called styles.default that is equivalent to a user-defined style then this will be used when no STYLE option is given to ODS HTML. For example, PROC TEMPLATE; * PATH SASUSER.TEMPLAT(update);…
To convert .wpd datasets to .sas7bdat datasets you can use PROC COPY with the appropriate database engine. For example, suppose you have .wpd datasets located at c:\Temp\altairslc\DATASET1.wpd etc … and an empty folder called c:\Temp\sas. The following code should generate an equivalent dataset1.sas7bdat dataset in…
When a LIBNAME statement makes a connection to an external database there is a default schema setup to read tables conforming to that schema. In the SQL server case this default schema name is dbo. So only database tables conforming to schema dbo will appear in the Server Explorer tab of the workbench. The schema= option…
Here is an example of using the DDEX engine for the FILENAME statement to update an existing sheet in an Excel workbook. The EXPORT procedure creates an initial file so that the DDEX interface can open to update with data. If you already have a file then the EXPORT procedure step is not required. /* Create a zipcode.xlsx…
These arguments can be used with ODBC engine for connecting to an SQLServer database on Windows. They allow the libname to pick up some/all of the local DSN configuration created in the Windows ODBC Data Sources utility, and potentially to tell Windows to pop up a prompt for any missing values. You specify these arguments…
Install R on Windows (version 2.1 and above - please use the latest) If you are using the Altair Analytics Workbench you may like to try setting the R_HOME environmental variable in the server->properties->launch options by adding a 'New' variable. Typically for Windows this would be set to something like C:\Program…
Download and install R on the MAC. Version 2.1 onwards - please use the latest. If you are using the Altair Analytics Workbench you may like to try setting the R_HOME environmental variable in the server->properties->launch options by adding a 'New' variable. Typically for a MAC this would be set to something like…
Introduction A PC user running SAS who is trying to connect to Altair SLC on a mainframe has to use the telnet protocol. There is a section in the Altair SLC Communicate document entitled 'Authentication on z/OS using telnet'. A user creates a telnet script to launch Altair SLC on a mainframe via a CLIST and TSOWPS options…
There's a wealth of content waiting for you to explore! Need support or have a question? Login or join our community.