Re: SAS 9.4
Aha, I agree with you on the installation of both products. On the usefulness I have differentiated opinions: Yes and Few. Kees. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Ken Smith Sent: 11 November, 2016 15:11 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SAS 9.4 Perhaps Dead is too strong. My dislike of SAS and Omegamon refers to their complex and difficult software installation. And for Omegamon it started as a simple product to use then morphed into a monster. My opinion only; if you've got them and they're useful, carry on. Ken On Tue, Nov 8, 2016 at 2:18 AM, Vernooij, Kees (ITOPT1) - KLM < kees.verno...@klm.com> wrote: > Sure? > Sas is not dead, it is expensive (if you can't negotiate), but not > difficult (in which language can you write the similar to PROC MEANS in the > same number of lines? > What about omegamon, is this dead too? > > Kees. > > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Ken Smith > Sent: 07 November, 2016 21:44 > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: SAS 9.4 > > SAS is dead; too expensive and too difficult. See also omegamon. > > On Monday, November 7, 2016, Steely.Mark > wrote: > > > I am new to SAS - does anyone have a SAS IVP program for DB2. The non DB2 > > program works - need something to test DB2. > > > > Any help would be appreciated. > > > > Thanks > > > > -- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to lists...@listserv.ua.edu with the message: > > INFO IBM-MAIN > > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > For information, services and offers, please visit our web site: > http://www.klm.com. This e-mail and any attachment may contain > confidential and privileged material intended for the addressee only. If > you are not the addressee, you are notified that no part of the e-mail or > any attachment may be disclosed, copied or distributed, and that any other > action related to this e-mail or attachment is strictly prohibited, and may > be unlawful. If you have received this e-mail by error, please notify the > sender immediately by return e-mail, and delete this message. > > Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its > employees shall not be liable for the incorrect or incomplete transmission > of this e-mail or any attachments, nor responsible for any delay in receipt. > Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch > Airlines) is registered in Amstelveen, The Netherlands, with registered > number 33014286 > > > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SAS 9.4
Perhaps Dead is too strong. My dislike of SAS and Omegamon refers to their complex and difficult software installation. And for Omegamon it started as a simple product to use then morphed into a monster. My opinion only; if you've got them and they're useful, carry on. Ken On Tue, Nov 8, 2016 at 2:18 AM, Vernooij, Kees (ITOPT1) - KLM < kees.verno...@klm.com> wrote: > Sure? > Sas is not dead, it is expensive (if you can't negotiate), but not > difficult (in which language can you write the similar to PROC MEANS in the > same number of lines? > What about omegamon, is this dead too? > > Kees. > > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Ken Smith > Sent: 07 November, 2016 21:44 > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: SAS 9.4 > > SAS is dead; too expensive and too difficult. See also omegamon. > > On Monday, November 7, 2016, Steely.Mark > wrote: > > > I am new to SAS - does anyone have a SAS IVP program for DB2. The non DB2 > > program works - need something to test DB2. > > > > Any help would be appreciated. > > > > Thanks > > > > -- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to lists...@listserv.ua.edu with the message: > > INFO IBM-MAIN > > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > For information, services and offers, please visit our web site: > http://www.klm.com. This e-mail and any attachment may contain > confidential and privileged material intended for the addressee only. If > you are not the addressee, you are notified that no part of the e-mail or > any attachment may be disclosed, copied or distributed, and that any other > action related to this e-mail or attachment is strictly prohibited, and may > be unlawful. If you have received this e-mail by error, please notify the > sender immediately by return e-mail, and delete this message. > > Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its > employees shall not be liable for the incorrect or incomplete transmission > of this e-mail or any attachments, nor responsible for any delay in receipt. > Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch > Airlines) is registered in Amstelveen, The Netherlands, with registered > number 33014286 > > > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SAS 9.4
Sure? Sas is not dead, it is expensive (if you can't negotiate), but not difficult (in which language can you write the similar to PROC MEANS in the same number of lines? What about omegamon, is this dead too? Kees. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Ken Smith Sent: 07 November, 2016 21:44 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SAS 9.4 SAS is dead; too expensive and too difficult. See also omegamon. On Monday, November 7, 2016, Steely.Mark wrote: > I am new to SAS - does anyone have a SAS IVP program for DB2. The non DB2 > program works - need something to test DB2. > > Any help would be appreciated. > > Thanks > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: > INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SAS 9.4
SAS is dead; too expensive and too difficult. See also omegamon. On Monday, November 7, 2016, Steely.Mark wrote: > I am new to SAS - does anyone have a SAS IVP program for DB2. The non DB2 > program works - need something to test DB2. > > Any help would be appreciated. > > Thanks > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: > INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SAS 9.4
To do this you need a db2 table you can write to. After that it is a simple process to code the SAS Samples available. I normally use PROC SQL and there is NO DB2 involved. So search on support.sas.com you should find some help there. Just a quick search provided this For example, if you submit a PROC PRINT statement that references a DB2 table, the DB2 SQL query is displayed in the SAS log. SAS/ACCESS Interface to DB2 under z/OS generates this query. libname mylib db2 ssid=db2; proc print data=mylib.staff; run; proc sql; select * from mylib.staff order by idnum; quit; So PROC SQL to a table you have update authority to should work. Lizette > > > -Original Message- > > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > > On Behalf Of Steely.Mark > > Sent: Monday, November 07, 2016 10:15 AM > > To: IBM-MAIN@LISTSERV.UA.EDU > > Subject: SAS 9.4 > > > > I am new to SAS - does anyone have a SAS IVP program for DB2. The non > > DB2 program works - need something to test DB2. > > > > Any help would be appreciated. > > > > Thanks > > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SAS 9.4
On Mon, Nov 7, 2016 at 11:39 AM, Steely.Mark wrote: > Thanks for the SAS List - I am not sure what I need - just need a program > to access DB2 and read and / or write a record. > > Thanks > > I know nothing of this. But doing a Google search turned up: https://support.sas.com/resources/papers/accessdb2.pdf http://support.sas.com/documentation/cdl/en/acreldb/69039/HTML/default/viewer.htm#titlepage.htm http://www.lexjansen.com/nesug/nesug02/bt/bt019.pdf http://www.okstate.edu/sas/v8/sashtml/accdb/z0267653.htm http://analytics.ncsu.edu/sesug/2001/P-108.pdf and many more. -- Heisenberg may have been here. Unicode: http://xkcd.com/1726/ Maranatha! <>< John McKown -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SAS 9.4
Thanks for the SAS List - I am not sure what I need - just need a program to access DB2 and read and / or write a record. Thanks -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Lizette Koehler Sent: Monday, November 07, 2016 11:20 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SAS 9.4 If you were not aware, there is a SAS-L list. SAS http://vm.marist.edu/archives/sas-l.html https://listserv.uga.edu/cgi-bin/wa?SUBED1=SAS-L They are very help when running sas. Also, the support teams are very helpful if you open a case with SAS on support.sas.com What specifically are you looking for. The support.sas.com has a good search engine and you should be able to find most answer there. Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > On Behalf Of Steely.Mark > Sent: Monday, November 07, 2016 10:15 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: SAS 9.4 > > I am new to SAS - does anyone have a SAS IVP program for DB2. The non > DB2 program works - need something to test DB2. > > Any help would be appreciated. > > Thanks -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SAS 9.4
If you were not aware, there is a SAS-L list. SAS http://vm.marist.edu/archives/sas-l.html https://listserv.uga.edu/cgi-bin/wa?SUBED1=SAS-L They are very help when running sas. Also, the support teams are very helpful if you open a case with SAS on support.sas.com What specifically are you looking for. The support.sas.com has a good search engine and you should be able to find most answer there. Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Steely.Mark > Sent: Monday, November 07, 2016 10:15 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: SAS 9.4 > > I am new to SAS - does anyone have a SAS IVP program for DB2. The non DB2 > program works - need something to test DB2. > > Any help would be appreciated. > > Thanks -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN