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.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.