Sorry if this is a stupid question, but we've just installed a new environment including VA and I'm trying to get my head around it. I've searched documentation without success. I clearly need to get some training but in the meantime...! Our environment consists of four servers: Metadata, Office Analytics, Visual Analytics and Middle Tier. SAS version is 9.4M5 and VA is 7.4, non-distributed. All four servers are Windows. We have a shed load of data on the OA server, migrated from our old environment. Most users currently use Enterprise Guide as their client software. I am trying to work out how to load data from the OA server into VA, either using VA itself or with the EG "Upload to LASR" task. With the former, I can see the source tables in the metadata folders but when I try loading them I get an error that the source library isn't assigned (unsurprisingly I suppose). When I try using the EG task it informs me that it is unable to locate any LASR libraries. There are IOLA libraries defined in the metadata and I assumed that these would be available to load to but I'm clearly missing something. I did watch part of a Youtube video from a couple of years ago, discussing how to do this, but it said that it only worked with a Linux VA server. I hope that's not still the case. Many thanks for any insights. ... View more

Anyone know if it's possible to change your email address and login for SAS Communities? I've got a new email address and, while my old one still works at the moment, I'm not sure that it will continue to do so. Thanks, Nigel Pain ... View more

I asked the following question on SAS Professionals so if you've seen it there please disregard. I'm trying to write some code, using the metadata data step functions, which will query specified identities metadata. Where an identity is a group, I then want it to get the members of that group, and then do that recursively until it is down to persons only. I can't think of a way of writing recursive code in a data step so I thought I'd try using macro code. However, the metadata functions don't seem to work with %sysfunc. This is demonstrated by this log extract: 15         %let rc=%sysfunc(metadata_getattr(&identuri,Name,ident_name)); 16         %put identuri=&identuri rc=&rc ident_name=&ident_name; WARNING: Apparent symbolic reference IDENT_NAME not resolved. identuri=OMSOBJ:IdentityGroup\A54UQ8A9.A300005Q rc=0 ident_name=&ident_name The ident_name macro variable never gets defined because it's not the function's return code, but one of the function's arguments. Can anyone suggest a way around this, or an alternative method? I don't know if it would be possible with PROC METADATA. I've never really got to grips with the XML for querying the metadata. Thanks ... View more

I've been experimenting with the macros for importing AD data and updating metadata with it (%mdu* in sasautos). One of the things I want to do is to populate the Description property of Person objects with a couple of pieces of information, put onto separate lines. I've tried embedding Carriage Return and Line Feed characters, and a combination of the two, but they seem to be stripped out when the metadata is updated. The macro that actually updates the metadata (%mduchlb) uses XML and PROC METADATA to do the actual updates so I'm wondering if this is what causes the character to be removed. Any ideas about this, or how I can get round it? Thanks, Nigel Pain ... View more