BookmarkSubscribeRSS Feed
lgsucupira
Fluorite | Level 6
Hello all well

I have a program in proc sql that collects information about user permissions. My question is is there a possibility to make changes to permissions using proc sql or do you have any specific proc command?

command made until now of collection would be this:

proc sql;
create table VA_Grupos as
select NOME_GRUPO, Login_Usuario, displayname, memDesc, title from
(select memid, name as NOME_GRUPO, memName as Login_Usuario, memDesc from dirm.Groupmempersons_info) as a left join
(select objid, title, displayname from dirm.person) as b on a.memid=b.objid
order by NOME_GRUPO, displayname;
quit;

proc sql;
create table VA_Usuarios as
select keyid, displayname, name, description,title from dirm.person
order by displayname;
quit;


Thanks

 

 
 
1 REPLY 1
ChrisNZ
Tourmaline | Level 20

What exactly are you trying to alter?

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 679 views
  • 0 likes
  • 2 in conversation