topic Re: code to read a file from meta data server through eg in SAS Programming

code to read a file from meta data server through eg

nagaraj1991 — Mon, 10 Sep 2018 14:17:31 GMT

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
;

Re: code to read a file from meta data server through eg

Kurt_Bremser — Mon, 10 Sep 2018 16:40:51 GMT

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?

Re: code to read a file from meta data server through eg

nagaraj1991 — Tue, 11 Sep 2018 11:18:01 GMT

Thanks Kurt for the reply.

We have four servers

Re: code to read a file from meta data server through eg

Kurt_Bremser — Tue, 11 Sep 2018 17:56:58 GMT

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