topic Re: ARM logging to a sas dataset? in SAS Data Management

ARM logging to a sas dataset?

dfs888 — Fri, 18 May 2012 23:13:59 GMT

Hi,

Does anyone know how to create a sas dataset from an ARM log?

I don't think running the %armproc and %armjoin macros alone will do it.

Thanks.

Re: ARM logging to a sas dataset?

LinusH — Mon, 21 May 2012 08:02:39 GMT

What version are you on?

I think from 9.3, this will wok almsot "out of the box", at least with some standard logging.

I couldn't fins any documentation of the data model, but I think it would be quite easy to figure it out by examine log files.

Re: ARM logging to a sas dataset?

shivas — Mon, 21 May 2012 09:37:20 GMT

Hi,

Check this links ...Hope it helps..

http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a002171886.htm

http://support.sas.com/documentation/cdl/en/armref/61526/HTML/default/viewer.htm#a003282868.htm

Thanks,

Shiva

Re: ARM logging to a sas dataset?

dfs888 — Tue, 22 May 2012 20:54:25 GMT

Thanks Shiva and Linus. I am using SAS92.

It looks like I'll need to get more detailed information from the arm logs than what the default provides. Using the macros ARMPROC and ARMJOIN did consolidate the log entries, but it's very basic information.

Re: ARM logging to a sas dataset?

RMP — Wed, 23 May 2012 07:34:43 GMT

Just curious dfs, what kind of information are you looking for?

Re: ARM logging to a sas dataset?

dfs888 — Wed, 23 May 2012 16:27:16 GMT

I was looking for details on what users are 'doing' in the olap cubes. that is, what cubes are they accessing, what they are querying, how long it takes, etc.

Re: ARM logging to a sas dataset?

shivas — Wed, 23 May 2012 16:59:24 GMT

Hi ,

Are you looking for some thing like SAS OLAP SERVER monitor(which is in SAS MC).It provide details like

Session Name: is generated when the session is established.
Session Owner: identifies the user that started the session. If the server is not secured, the displayed value is <unknown>.
Seconds Inactive: displays the time in seconds since the conclusion of the last query.
Size: displays the combined size, in bytes, of the result sets that are open in the session.
Result Sets Open

Thanks,
Shiva

Re: ARM logging to a sas dataset?

dfs888 — Fri, 25 May 2012 17:14:57 GMT

Yes, the monitor information seems helpful, but i would need a report generated from the sessions. Also, i don't know if i have the proper permissions on the Console.