code to read a file from meta data server through eg

[nagaraj1991]

Hi All,

I have a log file which resides in meta data server .

i need to import this log file through  sas eg and convert as data set.

But i am not able to access that log file through eg ,,i think by default it check for the file in compute server homefolder .

options metaserver = "fcmeta.ca"
metaport = 8561
metauser = "user"
metapass = "xxxxxx "
metarepository = Foundation
metaprotocol = bridge

data new;

infile "/home/hed/tataa.log";

-----

-----

run;

ERROR: Physical file does not exist

Please let me know how should i proceed .

I am actually new to sas programming ,,So please let me know where i am doing wrong
;

[Kurt_Bremser]

The metaoptions are for connecting to the metadata itself, not for files residing on the machine where the metadata server runs.

Is your workspace server on a machine separate from the metadata server?

[nagaraj1991]

Thanks Kurt for the reply.

We have four servers 

meta 

compute 

mid1

mid2

So when i give my home folder in code  it is checking for the files in  my home folder computer server .

So is there any way i can make it to check my meta data server home folder 

I am not sure i  have answered your question .Please let me know is there anything i could elaborate 

[Kurt_Bremser]

So your workspace server process runs on a machine separate from the metadata server. If you want to read metadata log files, you need some kind of accessto those.

Either have the necessary path from the metadata server mounted on the compute server, or use sftp access (servers should always have a SSH server active).