A space for data analytics & AI related technical resources and discussions.
Parameter dbmax_text is always in bytes. Format widths are also always in bytes.
Implicit passthrough is the default PROC SQL mode in Altair SLC. The Altair SLC (acting as database client) will process the PROC SQL and decide if certain portions of the query can be passed to the database to be processed more efficiently e.g libname mylib odbc ..connection-options..; proc sql; select * from…
Explicit passthrough is typically used when you wish to 1. pass the whole query to the DBMS without any intervention from PROC SQL. 2. pass some DBMS specific SQL syntax to the DBMS that does not form part of the standard PROC SQL syntax. Explicit passthrough is defined using the proc sql CONNECT, DISCONNECT, EXECUTE and…
You are logged into the Mainframe using your terminal emulator software. Using the ISPF editor, select each affected member, and type NUM OFF in the command line, then PF3 to save the edited member. That's it. You don't even need to check to see if the script has got sequence numbers or not – just edit every one in the…
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…
There's a wealth of content waiting for you to explore! Need support or have a question? Login or join our community.