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.
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.
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
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.
Just curious dfs, what kind of information are you looking for?
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.
Hi ,
Are you looking for some thing like SAS OLAP SERVER monitor(which is in SAS MC).It provide details like
is generated when the session is established.
identifies the user that started the session. If the server is not secured, the displayed value is <unknown>.
displays the time in seconds since the conclusion of the last query.
displays the combined size, in bytes, of the result sets that are open in the session.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.