Desktop productivity for business analysts and programmers

Transfer Data from an EG Profiles to an Other

Reply
New Contributor
Posts: 2

Transfer Data from an EG Profiles to an Other

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

SAS Super FREQ
Posts: 377

Re: Transfer Data from an EG Profiles to an Other

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

New Contributor
Posts: 2

Re: Transfer Data from an EG Profiles to an Other

Posted in reply to CaseySmith

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 Smiley Sad

Occasional Contributor
Posts: 5

Re: Transfer Data from an EG Profiles to an Other

[ Edited ]

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.

 

Super User
Posts: 3,768

Re: Transfer Data from an EG Profiles to an Other

[ Edited ]

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.

Ask a Question
Discussion stats
  • 4 replies
  • 119 views
  • 0 likes
  • 4 in conversation