Transfer Data from an EG Profiles to an Other

[Bunz]

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

[CaseySmith]

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

[Bunz]

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 😞

[NunoTGrunho]

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.

[SASKiwi]

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.