topic Re: Transfer Data from an EG Profiles to an Other in SAS Enterprise Guide

Transfer Data from an EG Profiles to an Other

Bunz — Fri, 27 Apr 2018 12:35:40 GMT

Hi there !

I really need your help to transfer large table from a Guide profile to an other.

I made a libname in my profile1 to create a large database and I need to access it from my profile2.

Should I use a libname statement or I have to download data from profile1 and upload to profile2 ?

The second way seems to be difficult because of lrage database...

Thanks in advance and sorry for my poor English

Re: Transfer Data from an EG Profiles to an Other

CaseySmith — Fri, 27 Apr 2018 13:51:15 GMT

Hi @Bunz,

Yes, you should use the same libname statement in both profiles to assign a library to the same data source (your large table). It is not necessary (and would be very inefficient and cumbersome) to have to recreate the data for each profile.

Casey

Re: Transfer Data from an EG Profiles to an Other

Bunz — Fri, 27 Apr 2018 13:55:28 GMT

Thanks for the answer but I think that my explanations are not clear...

I connect on 2 differents metadata servers, so, physically, one doesn't know the other...

It would be easy if I connect on the same metadata server but with 2 différents...

I checked the libname meta function but no result 😞

Re: Transfer Data from an EG Profiles to an Other

NunoTGrunho — Fri, 27 Apr 2018 15:04:52 GMT

Hi,

If you have SAS / Connect on your environments you could access remote data.

Ex:

%let remhost=1.2.3.4.65 7551;
options comamid=tcp remote=remhost NOCONNECTMETACONNECTION;
signon remhost user=user password="xxxxxxxx";

libname yourlib "/PATH/TO/YOUR/DATA" server=remhost;

You could also connect using a metadata connection specifying:

options metaserver="MetaHOST"
metaport=8561
metauser="USER"
metapass="PASS"
metaprotocol="bridge";

%let SasHost=hostname 7551;
signon SasHost authdomain=Auth;

libname yourlib "/PATH/TO/YOUR/DATA" server=SasHost;

If you don't have SAS / Connect or SAS / Share you could use a nfs share to make data available on both machines.

Re: Transfer Data from an EG Profiles to an Other

SASKiwi — Fri, 27 Apr 2018 23:27:49 GMT

Talk to your SAS administrator about setting up folder sharing between the two SAS environments. If they both use the same operating system it is the easiest way to share data. Then you don't need to copy the data between the two systems, just access the shared data from each system.