cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Petersas
‎05-26-2016
  • 10 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to connect to IMS database using SAS on mainframe

by Calcite | Level 5 in SAS Procedures
‎05-17-2016 02:36 AM
‎05-17-2016 02:36 AM
Hi Jan, I have check the link you have provided. can you share a sample program if you have for the same. Thanks, Peter ... View more

How to connect to IMS database using SAS on mainframe

by Calcite | Level 5 in SAS Procedures
‎05-16-2016 06:52 AM
‎05-16-2016 06:52 AM
Hi,   Can anyone let me know how to connect to IMS database and pull data from segment using SAS on mainframe.   Any help will be apprecitated.   Thanks, Peter. ... View more

Re: SAS-DB2 connectivity(mainframe)

by Calcite | Level 5 in SAS Procedures
‎12-31-2015 10:29 PM
‎12-31-2015 10:29 PM
Hi LinusH,   Where is your SAS program executing?   -- SAS is working on Mainframe. What kind of DB2 client are your using (native, ODBC)? -- SAS SQL PROC Do you have the necessary license? -- ---Base Product                          ---SAS/ACCESS Interface to DB2           ---SAS/ACCESS Interface to IMS-DL/I  Does anybody at your site managed to connect from SAS to this DB2 earlier?  Versions (SAS, DB2)...? -- SAS 9.1.3   Thanks.     ... View more

SAS-DB2 connectivity(mainframe)

by Calcite | Level 5 in SAS Procedures
‎12-31-2015 10:29 AM
‎12-31-2015 10:29 AM
Hi, I have a DB2 query in mainframe which is pulling data from tables. I'm currently trying to run the same DB2 query in SAS program and want to fetch the data from the tables. I'm new to SAS-DB2. Please provide me pointers on how to achieve this. I tried the following: PROC SQL; CONNECT TO DB2 (SSID=DBQ2); %PUT &SQLXMSG; CREATE TABLE SASDS AS SELECT * FROM CONNECTION TO DB2 ( SQL QUERY ); %PUT &SQLXMSG; DISCONNECT FROM DB2; %PUT &SQLXMSG;   but was getting error. ERROR: Unable to load the DB2 Call Attach Facility.   ERROR: A Connection to the DB2 DBMS is not currently supported, or IS not installed at your site. PROC SQL set option NOEXEC NOTE: Statement not executed due to NOEXEC option.   Please advise.   Thanks in Advance!!!   ... View more

Re: How to connect to oracle from sas to pull data from oracle?

by Calcite | Level 5 in ODS and Base Reporting
‎11-02-2012 12:09 PM
‎11-02-2012 12:09 PM
Thanks for your replies... Issue resolved. ... View more

Re: How to connect to oracle from sas to pull data from oracle?

by Calcite | Level 5 in ODS and Base Reporting
‎05-22-2012 03:42 AM
‎05-22-2012 03:42 AM
Oracle-client -- sqlplus- is installed on my station and i can run queries successfully from it. so how to get connected to oracle from SAS and get information from RDBMS tables into SAS for producing sas datasets. ... View more

Re: Variable vs Fixed

by Calcite | Level 5 in SAS Enterprise Guide
‎05-22-2012 01:00 AM
‎05-22-2012 01:00 AM
in case of infile use lrecl=x not sure about EG ... View more

Re: Most Recent Records

by Calcite | Level 5 in SAS Enterprise Guide
‎05-22-2012 12:55 AM
‎05-22-2012 12:55 AM
you can sort in the desc order and keep only the 1st record as mentioned above!!! ... View more

Re: How to connect to oracle from sas to pull data from oracle?

by Calcite | Level 5 in ODS and Base Reporting
‎05-21-2012 02:42 PM
‎05-21-2012 02:42 PM
is PROC SQL; QUIT; used ONLY to get data from dbms table like oracle,mssql  or  used to manipulate data present in SAS dataset? ... View more

How to connect to oracle from sas to pull data from oracle?

by Calcite | Level 5 in ODS and Base Reporting
‎05-21-2012 10:17 AM
‎05-21-2012 10:17 AM
Hi, I'm newbie to SAS, trying to learn SAS myself. Can anyone let me know how to connect to oracle from SAS and pull data from tables to create report. Any help will be appreciated. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-26-2016 09:29 AM
Quick links