About lfabbri

lfabbri · ‎03-08-2019

Hi @Mark_sas , thanks for the answer. I've tried already to start the deployment wizard, but in the products options for sas or related sas software there is no entry for "Operating System Services Scheduling" or anything similar. Do you know where is located to perform the installation from the wizard?

lfabbri · ‎03-06-2019

Hello everyone, I am trying to understand how can I schedule a job defined in SAS Data Integration Studio using the Management console. From this guide about SAS Scheduling it seems there are multiple ways to schedule a job: Flow Scheduler Platform Suite for SAS Operating system scheduler Distributed in-process scheduling In-process scheduling If I understand correctly some of these components require license, while others are not suited for deploying Data Integration jobs (e.g. In-process scheduling work only for reports, correct me if I'm wrong). For example in the documentation for the Flow Scheduler I read: To enable scheduling with SAS Job Flow Scheduler, you must set up a scheduling server. You must include SAS Job Flow Scheduler and the Web Infrastructure Platform Data Server in your plan file. You must select Web Infrastructure Platform Scheduling Services, SAS Job Flow Scheduler Server, SAS Job Flow Scheduler Orchestrator, and SAS Job Flow Scheduler Trigger in the SAS Deployment Wizard. If you are using SAS Job Flow Scheduler in a grid, you must also include SAS Grid Manager Control Server in your plan file and select SAS Workload Orchestrator in the SAS Deployment Wizard. If I run "proc init" from SAS console I can see the following products licensed: ---Base SAS Software 30MAY2019 ---SAS/CONNECT 30MAY2019 ---SAS Integration Technologies 30MAY2019 ---SAS/Secure 168-bit 30MAY2019 ---SAS/Secure Windows 30MAY2019 ---SAS/ACCESS Interface to Microsoft SQL Server 30MAY2019 ---SAS Metadata Bridges for General Industry Standards 30MAY2019 ---SAS Workspace Server for Local Access 30MAY2019 ---SAS/ACCESS to Postgres 30MAY2019 I've tried to deploy a job from Data Integration Studio and then to create a new Flow in the Scheduler from the Management Console, but when I've tried to edit the schedule options I got errors. I've also tried creating different scheduling server for the Flow (Operating System Services, Platform Process Manager, SAS In-Process Services), but no one worked. In particular I've tried to set up an Operating System Services scheduler following the steps in the documentation: To enable operating system scheduling, you must have a scheduling server. If you use the SAS Deployment Wizard to install and configure an operating system scheduling environment, all required items are automatically configured. You must include Operating System Services Scheduling Server 9.4 and SAS DATA Step Batch Server 9.4 in your plan file and select these two items in the SAS Deployment Wizard. The setup tasks are as follows: 1.Assign local administration rights to users (Windows only). 2.Assign directory and file permissions. 3.Define an operating system scheduling server. 4.Assign a spawner to the operating system scheduling server. On Windows systems, the user ID under which the job will be run must have Local Administration rights on the scheduling server. To grant these rights, add the user to the Administrators Group. This task is performed automatically by the SAS Deployment Wizard. 26 Chapter 4 • Setting Up Scheduling Using Operating System Scheduling Step 2: Assign Directory and File Permissions You must assign operating system Read and Write permissions to the following directories: Windows: •sas-config-dir/Lev1/SchedulingServer •sas-config-dir/Lev1/SchedulingServer/logs •sas-config-dir/Lev1/SchedulingServer/sasuser Note:You can use either forward or backward slashes on Windows systems. You must also assign Execute permission to sas-config-dir/Lev1/SchedulingServer/SchedulingServer.bat (Windows) or sas-config-dir/Lev1/SchedulingServer/SchedulingServer.sh Define an operating system scheduling server in the metadata repository. This task is performed automatically by the SAS Deployment Wizard. When created, the server definition has the following properties: SubType Specifies the operating system being used for scheduling Control Directory Contains the path for the directory that will store the script for executing a flow. For a default installation, the directory is sas-config-dir/Lev1/SchedulingServer. Command The appropriate SAS command for starting the scheduling server.. Sample commands are as follows: Step 3: Define an Operating System Scheduling Server 27 Windows: •"sas-config-dir\Lev1\SchedulingServer\Schedulingserver.bat" Object Server Parameters applevel=2 Authentication Domain DefaultAuth Host Name The name of the machine that hosts the scheduling server. Port 8451 I have to setup all manually, since these steps where not included during the installation of SAS. I have doubts about the "sas-config-dir\Lev1\SchedulingServer\Schedulingserver.bat" file, there is no such a file in my sas-config-dir\Lev1\SchedulingServer\ folder. I guess I need to create one, but I don't know what commands should be put in this .bat file. Please anyone can provide some help on how to correctly setup the operating system scheduler manually?

lfabbri · ‎01-22-2019

Because of the expiration of the SAS license we did a renewal of license. The renewal procedure has finished without errors. The problem is that after the renewal we got the following error when trying to execute a job in Data Integration Studio: "The application could not log on to the server "sas-data:8591". No server is available at that port on that machine." Searching on the web it seems the problem could be related to the Object Spawner. I've checked in the window services and it is indeed not running. I've tried to start the Object Spawner service but it stops as soon as it starts: I've tried also to reboot windows to see if the SAS servers correctly restarts, but nothing changed. Can anyone explain how to correctly restart SAS servers after a licenses renewal?

lfabbri · ‎01-14-2019

I've restarted the SAS Servers and now it is working fine. Thank you very much!

lfabbri · ‎01-14-2019

I am on a test environment with admin privileges. Following from here http://support.sas.com/kb/41/058.html I've enabled XCMD, but I got the same error when executing that code in DIS. This is the content of the C:\SAS\DIserver\Lev1\SASApp\WorkspaceServer\WorkspaceServer.bat file: @echo off REM /*--------------------------------------------------------------------\ REM | | REM | Script for managing the SAS Workspace Server | REM | | REM \--------------------------------------------------------------------*/ setlocal REM Define needed environment variables call "%~dp0..\appservercontext_env.bat" Set CONFIGDIR=%APPSERVER_ROOT%\WorkspaceServer call "%CONFIGDIR%\WorkspaceServer_usermods.bat" Set CMD_OPTIONS=-config "%CONFIGDIR%\sasv9.cfg" %* %USERMODS_OPTIONS% "%SAS_COMMAND%" %CMD_OPTIONS% endlocal REM Return the appropriate exit code exit %ERRORLEVEL% This is the content of the C:\SAS\DIserver\Lev1\SASApp\WorkspaceServer\WorkspaceServer_usermods file: REM /*--------------------------------------------------------------------\ REM | | REM | Script to extend WorkspaceServer.bat via user modifications. | REM | | REM \--------------------------------------------------------------------*/ Set USERMODS_OPTIONS= What can I do? Thank you for the support

lfabbri · ‎01-14-2019

Hi, I've tried your solutions and they works great in the SAS console. But when I tried a simple "User Written Code" node in Data Integration Studio with the following code: proc options option=(xcmd xsync JREOPTIONS); run; x 'java -version'; I got the following error: ERROR: shell escape is not valid in this SAS session. Do you know why I am getting this error in Data Integration and not in SAS console?

lfabbri · ‎01-10-2019

Hi @Kurt_Bremser, thank you for the answer! How can I know if XCMD is enabled on my SAS environment?

lfabbri · ‎01-10-2019

Is it possible to start/execute a java program from a jar file in a node of a Data Integration job and wait for completion (exit code 0)?

lfabbri · ‎01-10-2019

Hi @Patrick, thank you for the answer. My xml data need to be extracted from column records in a sql table: libname dbtest sqlsvr noprompt="uid=user; pwd=password; dsn=DBTEST;" stringdates=yes schema=DBO; filename tempfile "C:\SAS\TEMP\temp.xml"; data _null_; set dbtest.MY_XML_TABLE(firstobs=1 obs=1); file tempfile; put XML; run; This code can read and write one specific XML record to file. I am not sure how to apply your code to my use-case. Your loop "do id=1 to 2" iterates only on the first 2 rows?

lfabbri · ‎01-08-2019

Hi @jklaverstijn, thank you for the answer. My problem with this solution is that adding another nested level to the xml causes the failure of the parsing XML engine, which it seems does not support more than 3 levels deep in the hierarchy (from the documentation "Document can only be three levels deep, containing a root element, second-level elements corresponding to the table to be read in, and third-level elements corresponding to the variables"). Do you think is possibile to write a procedure like the following: For each row in the table: 1) extract the xml text from the column (only for the current row) 2) write the xml to a file on disk 3) load and parse the file with the sas xml engine 4) write the result to a target table In this way I won't need to add level to the hierarchy and the xml engine should be to parse the xml row by row. Apologies I am not very good at SAS syntax thus I am not sure how to properly write in SAS code the procedure above. Thanks for the support

lfabbri · ‎01-07-2019

Hi @jklaverstijn, thanks for your answer. If I understand correctly, your solution writes the entire table column to a file on disk and then use the XML engine to parse that file. I think this will fail since the engine expects one single root node, while here there are many (each row has a separate xml document). Also I would like to do it in memory, row by row, parse the field content and write to output without having to write the xml to disk. Is it possible?

lfabbri · ‎01-07-2019

Hi everyone I have a Microsoft SQL Table with a field which contains XML text. I need to parse the xml text contained in this field and output the result to another table in SAS Data Integration Studio. Actually I managed to parse the xml from a file on disk using the xml libname engine: libname in xml 'path\to\sample.xml'; data utente; set in.utente; run; proc print data=utente; run; How can I extract the xml text from SQL table field and use that as an input for the libname xml engine and output the result to another table? I need to do that in a Data Integration job. Thanks for any help!

lfabbri · ‎12-12-2018

Thank you very much, I've succesfully installed following your steps. Now I have a new problem...basically and the end of the update process the wizard said that it failed to start the SAS Object Spawner because the port was already used...I've tried to restart windows, stopped all the SAS services and tried again but got the same error. I've finished the installation anyway, skipping this error. Now my problem is that when I try to register tables in a new Sql Server library I can't performs the logon to the SasApp, even with the admin user: I think is probably related to the error on the SAS Object Spawner during the update process but I don't know how to solve it. In windows services the Object Spawner seems to be running, but maybe it is related to the previous installation? Any idea how to fix this issue?

lfabbri · ‎12-12-2018

Hi @nhvdwalt, what I did was to download the new order Software Depot on top of the existing software depot using the SAS Download Manager from here https://support.sas.com/downloads/browse.htm?fil=&cat=49. Is that correct?

lfabbri · ‎12-12-2018

SAS Installed Software And Components SASHOME: C:\Program Files\SASHome Host: wx6 Product: tablesrvtk Version: 9.4 Display Name: SAS Table Server Base Components Display Version: 9.4_M5 ------------------------------------------------------------------------------- Host: wx6 Product: tkintr Version: 9.4 Display Name: SAS Threaded Kernel Interface to R Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: aacomp Version: 15.1 Display Name: Advanced Analytics Common Components Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: inttechdoc Version: 9.4 Display Name: SAS Integration Technologies Documentation Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: activexgraph Version: 9.46 Display Name: SAS/GRAPH ActiveX Control Display Version: 9.46 ------------------------------------------------------------------------------- Host: wx6 Product: mgmtconsole Version: 9.4 Display Name: SAS Management Console Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: mvaviyadoc Version: 9.4M6 Display Name: SAS Viya Content MVA Help and Documentation Display Version: 9.4M6 ------------------------------------------------------------------------------- Host: wx6 Product: tksecure Version: 9.4 Display Name: SAS Threaded Kernel Secure Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: tk Version: 9.4 Display Name: SAS Threaded Kernel Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: tkbridge Version: 9.4 Display Name: SAS Threaded Kernel Component for Accessing the Threaded Kernel from JAVA Display Version: 9.4_M5 ------------------------------------------------------------------------------- Host: wx6 Product: securejavam4 Version: 9.4 Display Name: SAS/SECURE Java Component M4 Display Version: 9.4 ------------------------------------------------------------------------------- Host: wx6 Product: tkcore Version: 9.4 Display Name: SAS Threaded Kernel Core Routines Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: hptmine Version: 15.1 Display Name: SAS High-Performance Text Mining Server Components Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: tkolap Version: 9.4 Display Name: Threaded Kernel OLAP Server Component Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: tkjava Version: 9.4 Display Name: Threaded Kernel Java Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: odstemplate Version: 9.4 Display Name: ODS Templates Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: accesssample Version: 9.4 Display Name: SAS/ACCESS Interface Products Samples Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: hadoopwrapr Version: 9.46 Display Name: DataFlux API for Hadoop Display Version: 9.46 ------------------------------------------------------------------------------- Host: wx6 Product: mitibridges Version: 4.4 Display Name: SAS Metadata Bridges Display Version: 4.4 ------------------------------------------------------------------------------- Host: wx6 Product: analyticcmn Version: 15.1 Display Name: SAS Common Analytic Procedures Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: tkformats Version: 9.4 Display Name: SAS Threaded Kernel User Formats Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: win Product: tkaccess Version: 9.41 Display Name: SAS Threaded Kernel Extension for RDBMS Drivers Parser Display Version: 9.41_M4 ------------------------------------------------------------------------------- Host: wx6 Product: tkormp Version: 15.1 Display Name: SAS Threaded Kernel Extensions for Operations Research Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: etscomp Version: 15.1 Display Name: SAS/ETS Time Series & Econometric Modeling Common Components Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: tkmtrb Version: 9.42 Display Name: SAS Threaded Kernel Mid-tier Request Bridge Display Version: 9.42 ------------------------------------------------------------------------------- Host: wx6 Product: base Version: 9.4 Display Name: Base SAS Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: pcfile Version: 9.4 Display Name: SAS/ACCESS Interface to PC Files Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: econometrics Version: 8.3 Display Name: SAS Econometrics Procedures Display Version: 8.3 ------------------------------------------------------------------------------- Host: wx6 Product: mapssas Version: 9.43 Display Name: SAS/GRAPH Obsolete Maps Data Display Version: 9.43 ------------------------------------------------------------------------------- Host: win Product: eeditor Version: 9.46 Display Name: SAS Enhanced Editor Display Version: 9.46 ------------------------------------------------------------------------------- Host: win Product: iculib Version: 9.43 Display Name: International Component for Unicode Display Version: 9.43 ------------------------------------------------------------------------------- Host: win Product: securelite Version: 9.4 Display Name: SAS Proprietary Encryption Display Version: 9.4_M5 ------------------------------------------------------------------------------- Host: wx6 Product: tsmodel Version: 8.3 Display Name: SAS Time Series Modeling Procedures Display Version: 8.3 ------------------------------------------------------------------------------- Host: wx6 Product: tmine Version: 15.1 Display Name: SAS Text Miner Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: mitidiplug Version: 4.22 Display Name: SAS Metadata Bridges Plug-in for SAS Data Integration Studio Display Version: 4.22 ------------------------------------------------------------------------------- Host: wx6 Product: tkmysql Version: 9.4 Display Name: SAS Threaded Kernel Extension for MySQL Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: tknls Version: 9.4 Display Name: Threaded Kernel National Language Support Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: dmine Version: 15.1 Display Name: SAS Enterprise Miner Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: dproclient Version: 2.2 Display Name: SAS Deployment Tester - Client Display Version: 2.2_M6 ------------------------------------------------------------------------------- Host: wx6 Product: tkspddrv Version: 5.3 Display Name: SAS Threaded Kernel Drivers for Scalable Performance Data Display Version: 5.3_M3 ------------------------------------------------------------------------------- Host: wx6 Product: tkgraph Version: 15.1 Display Name: SAS Threaded Kernel Extensions for Graph Analytics Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: tkhphpf Version: 15.1 Display Name: SAS Threaded Kernel Extensions for High-Performance Forecasting Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: tkl4sas Version: 9.4 Display Name: Threaded Kernel Log for SAS Display Version: 9.4_M8 ------------------------------------------------------------------------------- Host: win Product: sasoledb Version: 9.46 Display Name: SAS Providers for OLE DB Display Version: 9.46 ------------------------------------------------------------------------------- Host: wx6 Product: privatejre Version: 9.47 Display Name: SAS Private Java Runtime Environment Display Version: 9.47 ------------------------------------------------------------------------------- Host: wx6 Product: prochttp Version: 9.42 Display Name: PROC HTTP Display Version: 9.42 ------------------------------------------------------------------------------- Host: wx6 Product: lasreng Version: 2.82 Display Name: SAS LASR Analytic Server Access Tools Display Version: 2.82 ------------------------------------------------------------------------------- Host: wx6 Product: tkoldoc Version: 9.4 Display Name: SAS Threaded Kernel Online Documentation Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: safmts Version: 9.4 Display Name: Standalone Formats Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: tkiml Version: 15.1 Display Name: SAS Threaded Kernel Extensions for Interactive Matrix Language Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: tkstat Version: 15.1 Display Name: SAS Threaded Kernel Extensions for Statistics Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: mvahelpdoc Version: 9.4 Display Name: Common Content MVA product Help and Documentation Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: graphapplet Version: 9.45 Display Name: SAS/GRAPH Java Applets for Web Servers Display Version: 9.45 ------------------------------------------------------------------------------- Host: wx6 Product: connectdrvrs Version: 9.4 Display Name: SAS/CONNECT Driver for Java Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: graphjars Version: 9.4 Display Name: SAS/GRAPH JAR Files Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: hpdmine Version: 15.1 Display Name: SAS High-Performance Data Mining Server Components Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: cmp Version: 9.46 Display Name: SAS Compiler and Symbolic Differentiator Display Version: 9.46 ------------------------------------------------------------------------------- Host: wx6 Product: tksecuressh Version: 2.82 Display Name: SAS Threaded Kernel Extension for SSH Remote Process Launching Display Version: 2.82 ------------------------------------------------------------------------------- Host: wx6 Product: stat Version: 15.1 Display Name: SAS/STAT Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: optimization Version: 8.3 Display Name: SAS Optimization Procedures Display Version: 8.3 ------------------------------------------------------------------------------- Host: wx6 Product: javaruntime Version: 9.4 Display Name: Java Platform Standard Edition Runtime Environment Display Version: ------------------------------------------------------------------------------- Host: wx6 Product: tkaa Version: 15.1 Display Name: SAS Threaded Kernel Extensions for Advanced Analytics Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: clientconfig Version: 5.2 Display Name: SAS Client Connection Profile Configuration Display Version: 5.2 ------------------------------------------------------------------------------- Host: wx6 Product: basestat Version: 15.1 Display Name: Base SAS Statistical Procedures Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: securestrong Version: 9.41 Display Name: SAS/SECURE Toolkit Libraries from RSA (R) Display Version: 9.41_M3 ------------------------------------------------------------------------------- Host: wx6 Product: tkgridjars Version: 9.43 Display Name: Threaded Kernel Grid JAR Files Display Version: 9.43 ------------------------------------------------------------------------------- Host: wx6 Product: mapsgfk Version: 9.43 Display Name: GfK GeoMarketing WORLD Maps for SAS/GRAPH Display Version: 9.43 ------------------------------------------------------------------------------- Host: wx6 Product: tkmpi Version: 2.82 Display Name: SAS Threaded Kernel Message Passing Interface Display Version: 2.82 ------------------------------------------------------------------------------- Host: wx6 Product: tkgrid Version: 9.4 Display Name: SAS Threaded Kernel Grid Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: tkbasestat Version: 15.1 Display Name: Base SAS Statistical threaded kernel extensions Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: tkhptmine Version: 15.1 Display Name: SAS Threaded Kernel Extensions for High-Performance Text Mining Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: tkqc Version: 15.1 Display Name: Threaded Kernel Extensions for SAS/QC Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: textmine Version: 8.3 Display Name: SAS Text Mining Process Display Version: 8.3 ------------------------------------------------------------------------------- Host: wx6 Product: tkhpdmine Version: 15.1 Display Name: SAS Threaded Kernel Extensions for High-Performance Data Mining Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: dminejars Version: 15.1 Display Name: SAS Enterprise Miner JAR Files Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: tstimeinfo Version: 8.3 Display Name: SAS Time Series Information Procedures Display Version: 8.3 ------------------------------------------------------------------------------- Host: wx6 Product: groovy Version: 9.410 Display Name: SAS Deployment Support Components Display Version: 9.410 ------------------------------------------------------------------------------- Host: wx6 Product: webinfdodbc Version: 9.45 Display Name: SAS ODBC Drivers for the Web Infrastructure Platform Data Server Display Version: 9.45 ------------------------------------------------------------------------------- Host: wx6 Product: scoreaccel Version: 8.3 Display Name: SAS Interface to Viya Model Publishing and Scoring Display Version: 8.3 ------------------------------------------------------------------------------- Host: wx6 Product: graph Version: 9.4 Display Name: SAS/GRAPH Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: tklasreng Version: 2.82 Display Name: SAS Threaded Kernel Extensions for LASR Analytics Server Access Tools Display Version: 2.82 ------------------------------------------------------------------------------- Host: wx6 Product: itclient Version: 9.49 Display Name: SAS Integration Technologies Client Display Version: 9.49 ------------------------------------------------------------------------------- Host: wx6 Product: mapsgeo Version: 9.43 Display Name: GfK GeoMarketing CITIES Maps for SAS/GRAPH Display Version: 9.43 ------------------------------------------------------------------------------- Host: wx6 Product: tkormpgraph Version: 15.1 Display Name: Threaded Kernel Extensions for Operations Research and GRAPH Analytics Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: secureclient Version: 9.4 Display Name: SAS/SECURE Client Components Display Version: 9.4_M5 ------------------------------------------------------------------------------- Host: wx6 Product: securejava Version: 9.4 Display Name: SAS/SECURE Java Component Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: tkhps Version: 2.2 Display Name: SAS Threaded Kernel Extensions for High-Performance Analytics Display Version: 2.2_M7 ------------------------------------------------------------------------------- Host: wx6 Product: connectdoc Version: 9.4M6 Display Name: SAS/CONNECT Help and Documentation Display Version: 9.4M6 ------------------------------------------------------------------------------- Host: wx6 Product: dproserver Version: 2.2 Display Name: SAS Deployment Tester - Server Display Version: 2.2_M6 ------------------------------------------------------------------------------- Host: wx6 Product: deployagent Version: 9.49580 Display Name: SAS Deployment Agent Display Version: 9.49580 ------------------------------------------------------------------------------- Host: wx6 Product: tktxtan Version: 15.1 Display Name: SAS Threaded Kernel Extensions for SAS Text Analytics Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: hpets Version: 15.1 Display Name: SAS High-Performance Econometrics Server Components Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: basejars Version: 9.4 Display Name: Base SAS JAR Files Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: eeditor Version: 9.46 Display Name: SAS Enhanced Editor Display Version: 9.46 ------------------------------------------------------------------------------- Host: wx6 Product: dminedoc Version: 15.1 Display Name: SAS Enterprise Miner Help and Documentation Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: verthelpdoc Version: 9.4M6 Display Name: Common Content product - vertical Help and Documentation Display Version: 9.4M6 ------------------------------------------------------------------------------- Host: wx6 Product: aastatistics Version: 15.1 Display Name: SAS Advanced Analytics Statistics Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: grsgeditor Version: 9.46 Display Name: SAS ODS Graphics Editor Display Version: 9.46 ------------------------------------------------------------------------------- Host: wx6 Product: tkmds Version: 2.1 Display Name: SAS Threaded Kernel Extension for In-Memory Data Storage Display Version: 2.1_M5 ------------------------------------------------------------------------------- Host: wx6 Product: instqualtool Version: 9.49516 Display Name: SAS Install Qualification Tool Display Version: 9.49516_M4 ------------------------------------------------------------------------------- Host: wx6 Product: databuildata Version: 4.7 Display Name: SAS Data Integration Studio Server Data Display Version: 4.7_M6 ------------------------------------------------------------------------------- Host: wx6 Product: iculib Version: 9.43 Display Name: International Component for Unicode Display Version: 9.43 ------------------------------------------------------------------------------- Host: wx6 Product: inttech Version: 9.4 Display Name: SAS Integration Technologies Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: connect Version: 9.4 Display Name: SAS/CONNECT Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: mtrb Version: 9.42 Display Name: Mid-Tier Rest Bridge Display Version: 9.42 ------------------------------------------------------------------------------- Host: wx6 Product: tkhpstat Version: 15.1 Display Name: SAS Threaded Kernel Extensions for High-Performance Statistics Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: statcomp Version: 15.1 Display Name: Statistics Common Components Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: certframe Version: 9.49580 Display Name: SAS Security Certificate Framework Display Version: 9.49580 ------------------------------------------------------------------------------- Host: wx6 Product: securelite Version: 9.4 Display Name: SAS Proprietary Encryption Display Version: 9.4_M5 ------------------------------------------------------------------------------- Host: wx6 Product: tkbridgejava Version: 9.4 Display Name: SAS Java Component for Accessing Threaded Kernel from Java Display Version: 9.4_M5 ------------------------------------------------------------------------------- Host: wx6 Product: txtancomp Version: 15.1 Display Name: SAS Text Analytics Common Components Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: txtandocconv Version: 15.1 Display Name: SAS Document Conversion Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: secupdate Version: 4.0 Display Name: SAS Security Update Display Version: 4.0 ------------------------------------------------------------------------------- Host: wx6 Product: tkspde Version: 9.41 Display Name: SAS Threaded Kernel Components for Scalable Performance Data Display Version: 9.41_M6 ------------------------------------------------------------------------------- Host: wx6 Product: tkdmine Version: 15.1 Display Name: SAS Threaded Kernel Extensions for Data Mining Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: databuilder Version: 4.7 Display Name: SAS Data Integration Studio Display Version: 4.7_M6 ------------------------------------------------------------------------------- Host: win Product: activexgraph Version: 9.46 Display Name: SAS/GRAPH ActiveX Control Display Version: 9.46 ------------------------------------------------------------------------------- Host: wx6 Product: hadoopcjars Version: 2.6 Display Name: SAS Hadoop Configuration Libraries Display Version: 2.6 ------------------------------------------------------------------------------- Host: wx6 Product: ets Version: 15.1 Display Name: SAS/ETS Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: tkodbc Version: 9.4 Display Name: SAS Threaded Kernel Extension for ODBC Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: hpstat Version: 15.1 Display Name: SAS High-Performance Statistics Server Components Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: graphdoc Version: 9.4M6 Display Name: SAS/GRAPH Help and Documentation Display Version: 9.4M6 ------------------------------------------------------------------------------- Host: wx6 Product: mrloginmgr Version: 9.4 Display Name: SAS Personal Login Manager Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: sasdocviewer Version: 9.46 Display Name: SAS Help Viewer for Windows Display Version: 9.46 ------------------------------------------------------------------------------- Host: wx6 Product: pcfiledoc Version: 9.4M6 Display Name: SAS/ACCESS Interface to PC Files Help and Documentation Display Version: 9.4M6 ------------------------------------------------------------------------------- Host: wx6 Product: mlearning Version: 8.3 Display Name: SAS Visual Data Mining and Machine Learning Procedures Display Version: 8.3 ------------------------------------------------------------------------------- Host: wx6 Product: accelmva Version: 3.1 Display Name: DATA Step to DS2 Translator Display Version: 3.1_M6 ------------------------------------------------------------------------------- Host: wx6 Product: securejavam5 Version: 9.4 Display Name: SAS/SECURE Java Component M5 Display Version: 9.4 ------------------------------------------------------------------------------- Host: wx6 Product: casconnctsub Version: 8.3 Display Name: Cloud Analytics Services Connection and Submission Client Display Version: 8.3 ------------------------------------------------------------------------------- Host: wx6 Product: tktslang Version: 9.41 Display Name: SAS Threaded Kernel DS2 and FedSQL Language Processors Display Version: 9.41_M4 ------------------------------------------------------------------------------- Host: wx6 Product: dprosmc Version: 9.4 Display Name: SAS Deployment Tester Plug-in for SAS Management Console Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: tkiog Version: 9.41 Display Name: SAS Threaded Kernel In-Database Supervisor Display Version: 9.41_M4 ------------------------------------------------------------------------------- Host: wx6 Product: tkspdsdrv Version: 5.4 Display Name: SAS Threaded Kernel Driver for SAS Scalable Performance Data Server Display Version: 5.4 ------------------------------------------------------------------------------- Host: wx6 Product: hadoopbasics Version: 9.46 Display Name: BASE Infrastructure to support Hadoop Display Version: 9.46 ------------------------------------------------------------------------------- Host: wx6 Product: tkaccess Version: 9.41 Display Name: SAS Threaded Kernel Extension for RDBMS Drivers Parser Display Version: 9.41_M4 ------------------------------------------------------------------------------- Host: wx6 Product: basedoc Version: 9.4M6 Display Name: Base SAS Help and Documentation Display Version: 9.4M6 ------------------------------------------------------------------------------- Host: wx6 Product: tsreconcile Version: 8.3 Display Name: SAS Forecast Reconciliation Procedures Display Version: 8.3 ------------------------------------------------------------------------------- Host: wx6 Product: deployagtclt Version: 9.49580 Display Name: SAS Remote Deployment Agent Client Display Version: 9.49580 ------------------------------------------------------------------------------- Host: wx6 Product: tkets Version: 15.1 Display Name: SAS Threaded Kernel Extensions for Econometric Time Series Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: inttechjars Version: 9.4 Display Name: SAS Integration Technologies JAR Files Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: tkpostgres Version: 9.4 Display Name: SAS Threaded Kernel Extension for PostgreSQL Display Version: 9.4_M5 ------------------------------------------------------------------------------- Host: wx6 Product: tkfnc Version: 9.4 Display Name: SAS Threaded Kernel User Functions Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: postgres Version: 9.4 Display Name: SAS/ACCESS Interface to PostgreSQL Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: tkcmp Version: 9.47 Display Name: SAS Thread-safe Compiler and Symbolic Differentiator Display Version: 9.47 ------------------------------------------------------------------------------- Host: wx6 Product: hpsdoc Version: 2.1 Display Name: SAS High Performance Server Help and Documentation Display Version: 2.1_M6 ------------------------------------------------------------------------------- Host: wx6 Product: grodscrender Version: 9.45 Display Name: SAS ODS Graphics C Renderer Display Version: 9.45 ------------------------------------------------------------------------------- Host: wx6 Product: vertviyadoc Version: 9.4M6 Display Name: SAS Viya Content Vertical Help and Documentation Display Version: 9.4M6 ------------------------------------------------------------------------------- Host: wx6 Product: mysql Version: 9.4 Display Name: SAS/ACCESS Interface to MySQL Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: graphcomp Version: 15.1 Display Name: SAS Network Algorithms Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: dmscore Version: 9.4 Display Name: SAS Data Mining Scoring Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: odbc Version: 9.4 Display Name: SAS/ACCESS Interface to ODBC Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: tkhpets Version: 15.1 Display Name: SAS Threaded Kernel Extensions for High-Performance Econometrics Display Version: 15.1 ------------------------------------------------------------------------------- Host: win Product: tkpostgres Version: 9.4 Display Name: SAS Threaded Kernel Extension for PostgreSQL Display Version: 9.4_M5 ------------------------------------------------------------------------------- Host: win Product: secureclient Version: 9.4 Display Name: SAS/SECURE Client Components Display Version: 9.4_M5 ------------------------------------------------------------------------------- Host: wx6 Product: baseui Version: 9.4 Display Name: Base SAS User Interface Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: tkjavajars Version: 9.4 Display Name: Threaded Kernel Java Jars Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: ttfontsvert Version: 9.45 Display Name: Report Fonts for Clients Display Version: 9.45 ------------------------------------------------------------------------------- Host: wx6 Product: tkcas3rdclnt Version: 9.61 Display Name: SAS Cloud Analytic Services support for Third Party Clients Display Version: 9.61 ------------------------------------------------------------------------------- Host: wx6 Product: or Version: 15.1 Display Name: SAS/OR Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: mitismc Version: 4.22 Display Name: SAS Metadata Bridges Plug-in for SAS Management Console Display Version: 4.22 ------------------------------------------------------------------------------- Host: wx6 Product: tktscore Version: 9.4 Display Name: SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: platfmltypes Version: 9.4 Display Name: SAS Intelligence Platform Object Framework Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: tkmeta Version: 9.4 Display Name: Threaded Kernel Metadata Component Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: win Product: safmts Version: 9.4 Display Name: Standalone Formats Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: tksaslaunch Version: 9.46 Display Name: SAS TK Launcher Display Version: 9.46 ------------------------------------------------------------------------------- Host: wx6 Product: secupdate2 Version: 2.0 Display Name: SAS Security Update 2 Display Version: 2.0 ------------------------------------------------------------------------------- Host: wx6 Product: sasoledb Version: 9.46 Display Name: SAS Providers for OLE DB Display Version: 9.46 ------------------------------------------------------------------------------- Host: wx6 Product: securedom Version: 9.41 Display Name: SAS/SECURE Display Version: 9.41_M3 ------------------------------------------------------------------------------- Host: win Product: itclient Version: 9.49 Display Name: SAS Integration Technologies Client Display Version: 9.49 ------------------------------------------------------------------------------- Host: wx6 Product: securejavam3 Version: 9.4 Display Name: SAS/SECURE Java Component M3 Display Version: 9.4 ------------------------------------------------------------------------------- Host: wx6 Product: iml Version: 15.1 Display Name: SAS/IML Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: hps Version: 2.2 Display Name: SAS High-Performance Server Display Version: 2.2_M7 ------------------------------------------------------------------------------- Host: wx6 Product: spdsclient Version: 5.4 Display Name: SAS Scalable Performance Data Client Display Version: 5.4 ------------------------------------------------------------------------------- Host: wx6 Product: dminelogtype Version: 15.1 Display Name: SAS Enterprise Miner Logical Types Display Version: 15.1 ------------------------------------------------------------------------------- Host: wx6 Product: tkiom Version: 9.4 Display Name: Threaded Kernel IOM Display Version: 9.4_M6 ------------------------------------------------------------------------------- Host: wx6 Product: databldjars Version: 4.8 Display Name: SAS Data Integration Studio Server JARs Display Version: 4.8_M5 ------------------------------------------------------------------------------- Host: wx6 Product: forecast Version: 8.3 Display Name: SAS Forecasting Procedures Display Version: 8.3 ------------------------------------------------------------------------------- Host: wx6 Product: cas Version: V.03.04 Display Name: SAS Cloud Analytic Services SAS Client Display Version: V.03.04 ------------------------------------------------------------------------------- SAS/ACCESS interface to Microsoft SQL Server is not present. But in the Deployment Wizard, when I select my order, the product is present:

Online Status	Offline
Date Last Visited	‎07-30-2019 08:51 AM

Re: Scheduling Data Integration Studio jobs from SAS Management Consol...

Scheduling Data Integration Studio jobs from SAS Management Console

SAS licenses renewal: no server is available at that port on that mach...

Re: Execute Java program (from jar file) inside a job node

Re: Execute Java program (from jar file) inside a job node

Re: Execute Java program (from jar file) inside a job node

Re: Execute Java program (from jar file) inside a job node

Execute Java program (from jar file) inside a job node

Re: Parse XML text from SQL table field

Re: Parse XML text from SQL table field

Re: Execute Java program (from jar file) inside a job node

Re: Execute Java program (from jar file) inside a job node

Re: Execute Java program (from jar file) inside a job node

Re: Execute Java program (from jar file) inside a job node

Re: Execute Java program (from jar file) inside a job node

Re: How to use Microsoft Sql Server as source/destination in SAS Data ...

Re: How to use Microsoft Sql Server as source/destination in SAS Data ...

Re: Steps to register Microsoft SQL Server Library (no ODBC library) i...

Re: Steps to register Microsoft SQL Server Library (no ODBC library) i...

Re: How to make an ODBC library available for all SAS users

Re: Scheduling Data Integration Studio jobs from SAS Management Consol...

Scheduling Data Integration Studio jobs from SAS Management Console

SAS licenses renewal: no server is available at that port on that mach...

Re: Execute Java program (from jar file) inside a job node

Re: Execute Java program (from jar file) inside a job node

Re: Execute Java program (from jar file) inside a job node

Re: Execute Java program (from jar file) inside a job node

Execute Java program (from jar file) inside a job node

Re: Parse XML text from SQL table field

Re: Parse XML text from SQL table field

Re: Parse XML text from SQL table field

Parse XML text from SQL table field

Re: Install new SAS/ACCESS interface from a new order on top of existi...

Re: Install new SAS/ACCESS interface from a new order on top of existi...

Re: Install new SAS/ACCESS interface from a new order on top of existi...