Desktop productivity for business analysts and programmers

SAS on Mainframe

Reply
Occasional Contributor SP2
Occasional Contributor
Posts: 8

SAS on Mainframe

I have a Unix SAS Account (SAS 9.1) . I have a Mainframe account.How do I get data from mainframe to SAS? Right now I can only view what is inside the mainframe.I need to pull the data. Anybody have any idea?
Thanks
Super Contributor
Super Contributor
Posts: 3,174

Re: SAS on Mainframe

You will need to use the SAS XPORT (transport) engine/format to copy (using PROC COPY as well) your SAS Unix data to the mainframe system. Each OS has a companion guide which has information. Also, the SAS support http://support.sas.com/ website has information about using LIBNAME XPORT facility to prepare you SAS data libraries and catalogs for transfer via FTP typically from your source to your target system environment. You will also have considerations with SAS source code and backup/recovery procedures if you are moving your SAS application processing to the mainframe environment.

Scott Barry
SBBWorks, Inc.
Esteemed Advisor
Posts: 5,198

Re: SAS on Mainframe

It's not clear whether you have SAS on the mainframe or not? If so, what version? If you also have a license for SAS/CONNECT, PROC DOWLOAD is usually the most convenient way to transfer SAS data between hosts.

Be aware of that the XPORT engine does not support V9 feature set for SAS tables, such as long table/column names. An alternative would be using PROC CPORT/CIMPORT.

If you don't have SAS on the mainframe (and the mainframe data is not SAS data sets), please explain more of what type of data you are dealing with.

/Linus
Data never sleeps
Respected Advisor
Posts: 3,837

Re: SAS on Mainframe

"Right now I can only view what is inside the mainframe" ....
How? As you ask this question in the SAS EG corner: Viewing with SAS EG?
Esteemed Advisor
Posts: 5,198

Re: SAS on Mainframe

Agree that this is probably not an EG thread.
The problem is that there is such of variety of SAS users, problems, etc. The best would be to have forums that would cover all SAS topics, but that would almost impossible. This thread could be placed in a architecture/host forum.
But I think that it's better that these questions are being asked/answered in a forum with a different subject, rather than not being asked at all.
I think it's up to the forum administrator to maintain the forums and their content.

/Linus
Data never sleeps
Respected Advisor
Posts: 3,837

Re: SAS on Mainframe

Linus

I asked the question about viewing the ds because the problem might be much simpler than it sounds - if only we get the all the info.

About the number of forums: Please not more of them! There are already too many right now for my taste.

Cheers, Patrick
Community Manager
Posts: 2,697

Re: SAS on Mainframe

Let's pretend there is SAS on the mainframe and SAS on Unix, and you have EG that can connect to them both.

Let's further pretend, in my little hypothetical answer, that you have SAS 9.2 in both places and EG 4.2.

You *could* use the Tasks->Data->Download task to download the data from the mainframe to your PC. And then you could use the Data->Upload task to upload it to Unix. Yes, it's two hops, but you'd be surprised how fast the data can move.

I'm pretty sure that this answer doesn't help the original poster, since the environment is too different from my pretend environment. But at least the people lurking on the forum might have learned something in this otherwise "off topic" thread...

Chris
Occasional Contributor
Posts: 5

Re: SAS on Mainframe

I assume, unlike the others, that SAS isn't on the mainframe. In that case you have a few options:

Read directly using ftp access method and appropriate formats (s370 series)

If data is text, and doesn't contain binary / packed or other mainframe formaatted fields, ftp to the unix box and let ftp do the conversion from ebcdic to ascii.

There are other ways, but these are simple and straightforward.
Ask a Question
Discussion stats
  • 7 replies
  • 187 views
  • 0 likes
  • 6 in conversation