Hi All, sorry to bother. any help on this please. ... View more

Hi @gwootton , iam trying below code to remove existing description but it is not working and reflecting in SMC actually retirn code =-3 getting . please help. data _null_; set work.Person(where=(keyid='XXXX')); if name = "sasadm" or name = "sasevs" or name = "sastrust" then put "Account is sasadm, sasevs or sastrust, skipping."; else do; if description ne "" then do; obj="omsobj:Person?@Name='"||name||"'"; rc=metadata_setattr(obj,"Desc",""); end; end; run;  Note : iam using correct keyid value. please help ... View more

No.it's not getting update please . i tried by removing the space also ... View more

Hi @gwootton , iam trying below code for one record to test if group is SASAdministartor then Desc should be SAS Adminstartors. But in SAS EG code it runs fine with out errors but i can not see the changes as expected in SMC    data _null_; set work.groupmempersons_info(where=(memid='XXXXXX')); length desc $255; call missing (desc); if memName = "sasadm" or memname = "sasevs" or memname = "sastrust" then put "Account is sasadm, sasevs or sastrust, skipping."; else if Name='SAS Administrators' then desc='SAS Administrators'; rc=metadata_setattr(obj,"Desc",desc); run; ... View more

Thanks @gwootton  it is working.. i took the backup and tested for single record and i can see that for roles 'SAS admintsrator's' and DI Deveopers for my name came to description filed as 'SASAdministrators,DI Developers'.   But i need to display under description filed in customised format please.. for example if role in (SAS admintsrator's' and DI Deveopers) then description should be 'SAS Administrator'  if role in (DI Deveopers) then Description should be S'AS Developer ' Actually i am having set of roles for which i need to create customised the description values based on roles for users. Would you please guide on this please and i thank you so much for your help on this please ... View more

NO...please.sorry for miscommunication I need to update the SAS metadata i mean SAS user when it is registered in SMC, the description filed will be there right ? that info i need to remove existing description and add decription for every user based on some conditions using groups & roles that are defined for each user. for example if user is having SAS Administrator ruler then description should be updated as SAS Admin..like this please.   i can see groups & roles are under showing name column in GROUPMEMPERSONS_INFO dataset file. So i can see description column in person.person_info datasets .   please note that it is not normat data step. i need help on data step metadata functions to do this job please and not using importad.sas program pleaase ... View more

I want to clean up the userid,displayname,jobid and email fields. So i got below code from you on SAS site please. So iam trying to understand the code. here library adir = i am giving myown work path updates = i am giving my own work path So i run below macro in eg and it got extracted into work library using mduextr . thanks @Kurt.Iam ver new to SAS Admin please.sorry to trouble you with simple things, even though myimportad.sas is present in include path, it is telling WARNING: Physical file does not exist. Iam sorry for my poor communication. Basically iam trying below code to do clean up and given my own directory for adir ,updates library and iam not able to get "Extract identity information from AD (". Request to please point me in right direction please.   ... View more

Hi @Kurt_Bremser ,   sorry to ask in this thread, i am unable to raise new thread, i need to do the clean up on SAS SMC for users: userid,name,display name.description options in SAS SMC. how do i copy  the resulting library (meta) to a new location Actually i am running below  code in SAS EG and iam getting error as  "ERROR: Libname META is not assigned."   %mduextr(libref=meta); would you please suggest how can i copy to new location and them modify and then  update the data directly in SAS SMC please   ... View more

hi @Kurt_Bremser , found that remote server was making use of TLS 1.2 version for FTP connection. but in my case SAS does not support  TLS 1.2 version and only supports TLS 1.0 verison. but same connection where SFTP with SSH keys works fine when i ran command via putty application. but same command gets failed with segmentaion error in SAS EG,do you think it is due to TLS version please..   So If it is due to TLS version may i know why & how please.         ... View more