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?
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.
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.
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.
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...