About pbad

pbad · ‎03-11-2019

Hi, It is not clear if this upgrade is for windows/Linux/Mainframe server installation or on the single/multiple machines. Please clarify what is the imapct size. There are list of activities you need to perform before you start your upgrade. Probably we can discuss in detail, once you answer the first question. Thanks Pratik

pbad · ‎03-11-2019

Hi No the errors are not the actually one, documented here. I have received the following reply from SAS. The fix came in at 9.4M3 ad above so is not available for M2. Existing modules can still be used in an LE environment by coding the *Z control argument. i.e.CALL MODULE('*Z','xxx',yyy,zzz); This control argument will not invoke IGZERRE since it is not supported in an LE environment. However, there could be a severe performance impact in not doing so. The V01044 provides a performant way of using CALL MODULE in an LE environment starting at M3. My suggestion would be to try the *Z control argument to determine if any performance impact is encountered. If the module is called only a few times then any impact will be minimal. If the module is called tens of thousands of times then the time to create the runtime environment on each call may be significant.

pbad · ‎03-07-2019

Hi Forgot to mention that users are calling Cobol module from SAS. This Cobol module is having DB2 calls, required to fetch the db2 data. Hence language interface is required to connect to SAS - Cobol - DB2. Unfortunately Hot Fix V01044 is not useful for SAS TS1M2.

pbad · ‎03-06-2019

Dear team, Very Good Morning, We are using SAS 9.4 TS1M2 sas in zos enviroment. In order to use LE module inside JCL to connect to Cobol program Hot Fix V01044 might work but this hotfix can be used in TS1M3 or later versions. Basically we are trying to call Cobol db2 modules inside SAS program. Do you suggest any other alternatve technique to connect to Cobold module inside SAS zos. I have created track with SAS but thought to consult a great pool of SAS experts 🙂 Please advice if you have any other alternative approach in mind. Regards, Pratik

pbad · ‎03-06-2019

Hi All, I am sorry for being late for everyone's reply. It was a great involvement from all of you. There was no warning or error from SAS EG, however since we update license on yearly basis so we had to analyse all the SAS softwares and their license expiration. We created new SAS EG package so the issue got solved. Thanks Pratik

pbad · ‎02-18-2019

Dear all, Thanks for your answers. I do have few points to share - 1) I am not getting any message from SAS EG about sas expiration date, however the SAS Foundation installed on server side and locally was getting expired on March 03, 2019. SAS license on SAS Foundation (local + server) is already updated. 2) It is true that while installing SAS EG we need to supply license file. This is very contradictory statement. If SAS EG depends upon the Local SAS / Server SAS license than why we need to supply SAS license during the time of SAS EG installation ? 3) This SAS article 'http://support.sas.com/kb/33/359.html' says that SAS EG has build in expiration date. If SAS EG has build in expiration date than why it needs license file at the time of SAS EG installtion ? 4) We are using SAS EG 7.15 HF2 (7.100.5.6112) (32-bit). Thanks Pratik

pbad · ‎02-18-2019

Dear all, Thanks for your answers. I do have few points to share - 1) I am not getting any message from SAS EG about sas expiration date, however the SAS Foundation installed on server side and locally was getting expired on March 03, 2019. SAS license on SAS Foundation (local + server) is already updated. 2) It is true that while installing SAS EG we need to supply license file. This is very contradictory statement. If SAS EG depends upon the Local SAS / Server SAS license than why we need to supply SAS license during the time of SAS EG installation ? 3) This SAS article 'http://support.sas.com/kb/33/359.html' says that SAS EG has build in expiration date. If SAS EG has build in expiration date than why it needs license file at the time of SAS EG installtion ? 4) We are using SAS EG 7.15 HF2 (7.100.5.6112) (32-bit). Thanks Pratik

pbad · ‎02-18-2019

Dear team, License is getting expired on March 03 for SAS EG. Wondering if SAS EG license is required to be renewed since we are not able to find any place for license file / SID file in our SAS EG packages. Does it means SAS EG will not be functional after March 03 ? On another note SAS EG is not getting installed manually with expired license file, that means SAS EG packages will need the new license. So we need to create a fresh package I guess and decommision the old one. The reason for asking this question is, we do not want to spend time to create new package if SAS EG license could be updated easily. What is your opinion ? Thanks Pratik

pbad · ‎10-14-2018

Dear Kurt, Thank you for your reply. It is not the multi-tiered server setup. Everything is lying on single SAS server. Pratik

pbad · ‎10-12-2018

http://support.sas.com/documentation/cdl/en/vaicg/69988/HTML/default/viewer.htm#n02025sasvanalytics00install.htm is the right link.

pbad · ‎10-12-2018

Dear all, We have a requirement where we have to transfer our SAS servers to Enclave Network model. At the moment our servers are on Legacy system. I understand that SAS has got predefined ports for SAS components. However following link says that for 'TCP port for middle-tier cache communications', the default port varies from 0 to 65535 and for the 'Cache Locator membership port range' needs 1024–65535 ports. So I was wondering whether Network team needs to open such a huge number of ports for the new system ? or it is ok if only few ports are defined. Should I understand that Network team has to open so many firewall rules ? http://support.sas.com/documentation/cdl/en/biig/62611/HTML/default/viewer.htm#n02027intelplatform00install.htm This is for sure that different client are going to connect to SAS servers. Does it make a difference if Servers are on Legacy or Enclave system ? I will appreciate to discuss on this topic. Thanks Pratik

pbad · ‎07-20-2018

Dear all Thanks for your response. I have used the combination of tagsets.excelXP and proc report to solve it. OPTIONS NODATE center; title; footnote; ods listing close; ods escapechar="^"; ods tagsets.ExcelXP file="/tmp/&sysuid. abc.xlsx" options (Embedded_Titles = 'yes' Embedded_footnotes = 'yes' sheet_name="&header"); proc report data=pppp Headline Headskip Split='*' style(report) = [frame = box borderwidth = 2 ] style(header) = [font_weight = bold font_size = 2.0] style(column) = [font_weight = medium background = beige font_size = 2.0] ; column aaaa bbbb cccc; define aaaa /display analysis sum 'dddd' format=numx14.2; define bbbb /display 'ttttt' style(column)={tagattr='0000000000'}; define cccc /display 'Bogf. ref.' ; title1 JUSTIFY=LEFT "&Header"; title2 JUSTIFY=RIGHT "printet d.&ds&kl"; RBREAK AFTER /SUMMARIZE; COMPUTE after; type = 'dddd'; endcomp; run; ODS TAGSETS.EXCELXP CLOSE; ods _all_ close; ods listing; filename mail email subject="The &header file for your reference" to = abcd from = abcd attach =( "/tmp/&sysuid. pay.xlsx" ext="xls" name="&header"); run; data _null_; file mail; put "Automatic email for &header sent from SAS job"; run;

pbad · ‎06-07-2018

Dear team, I am trying to install SAS on zos mainframe test environment where already SAS is installed. As soon as I am reaching the last stage after running my installtion script (./setup.rexx -nojobsubmit -console) I donot gets any Error/Success message and looks like some kind of error (Exception in thread "Thread-28" java.lang.NullPointerException). I am not sure why this is happening. Please note that SAS is already running successfully in test environment but I am trying to create installtion files so that i will update SAS 9.4 M2 with SAS 9.4 M5. Could you please have a look. I am using Java Runtime Environment: /usr/lpp/java/J7.0 and SASHome: /home/xxxxx/SASHome but not the usr/lpp as used for the first installation. Thanks for your support. Installation screen:- Step 1 of 153: Installing SAS Deployment Manager................................ ................................................................................ ................................................................................ ................................................................................ ................................................................................ ................................................................................ ....................Exception in thread "Thread-28" java.lang.NullPointerExcepti on at com.sas.ssn.DepotManagerÅJob.moveFile(DepotManager.java:878) at com.sas.ssn.DepotManagerÅJobÅEntity.move(DepotManager.java:1145) at com.sas.ssn.DepotManagerÅAddJob.run(DepotManager.java:2006) at com.sas.ssn.Chaining.launchInstall(Chaining.java:1247) at com.sas.ssn.Chaining.installNext(Chaining.java:580) at com.sas.ssn.Chaining.run(Chaining.java:309) Deployment Summary Summary: Stage 1: Installation 1 - SAS Deployment Manager 2 - SAS/SECURE Java Component for z/OS 3 - SAS/SECURE Java Component for z/OS (Update) 4 - SAS Integration Technologies Documentation 5 - SAS/ACCESS Interface to IMS Help and Documentation Please let me know if you have any info Thanks Pratik

pbad · ‎04-24-2018

pls see the attachment (sample data). This is in notepad. Yes, the program is in Mainframe. Only problem is header position to get it, trying to get it using different SAS procedures 🙂

pbad · ‎04-24-2018

Thanks, You assumption is absolutely correct 🙂 The report was created many years back when there were very few SAS solutions. Existing report is getting created on Mainframe and it is created for getting the prints on printer. I will share the sample report, however I have created the notepad file and trying to get the excel sheet.

Online Status	Offline
Date Last Visited	‎07-28-2021 08:51 AM

Re: Upgrade SAS 9.4 M2 to SAS 9.4 M5

Re: Connecting a Cobol SAS module from SAS 9.4 TS1M2

Re: Connecting a Cobol SAS module from SAS 9.4 TS1M2

Connecting a Cobol SAS module from SAS 9.4 TS1M2

Re: SAS EG license upate

Re: SAS EG license upate

Re: SAS EG license upate

SAS EG license upate

Re: Number of ports for SAS on network model Legacy or Enclave

Re: Number of ports for SAS on network model Legacy or Enclave

Re: SAS EG license upate

Re: SAS EG license upate

Re: SAS EG license upate

Re: SAS EG license upate

Re: SAS installation on z/OS

Number of ports for SAS on network model Legacy or Enclave

SAS installtion at zos test environment

SAS license renewal getting failed

Re: ERROR: The JSON engine cannot be found

Re: SAS installation on z/OS

Re: Upgrade SAS 9.4 M2 to SAS 9.4 M5

Re: Connecting a Cobol SAS module from SAS 9.4 TS1M2

Re: Connecting a Cobol SAS module from SAS 9.4 TS1M2

Connecting a Cobol SAS module from SAS 9.4 TS1M2

Re: SAS EG license upate

Re: SAS EG license upate

Re: SAS EG license upate

SAS EG license upate

Re: Number of ports for SAS on network model Legacy or Enclave

Re: Number of ports for SAS on network model Legacy or Enclave

Number of ports for SAS on network model Legacy or Enclave

Re: Change the reprot from printer to excel

SAS installtion at zos test environment

Re: Change the reprot from printer to excel

Re: Change the reprot from printer to excel