Hi All, I want to set up a program (as a stored process) that will allow people in my company to be registered as a user via a web form. On the public kiosk of our portal I have a url portlet pointing to a home page. I have a form on this page where a user requests access and then an admin adds the user and the user to groups and channels. I want to automate this part by following the below process. 1. User goes to our portal 2. User requests access adding; a. Network Username b. Full Name c. Role d. Department e. Manager f. Contact Number g. Email h. Groups they want access to (currently drawn from our metadata server) 3. User is added with the following details created; a. User Full Name b. Department added to the Description Field c. Username added to logins with authentication domain as 'Default Auth' d. Email & Phone added e. Role,Department,Manager added as custom attributes f. User assigned to the group 'Environ Users' 4. Email sent to both user and Admin notifying them they have been added. What I am looking for is a code snippet that shows me how I can programatically; a. Add a user to our metadata server b. Assign a login with DefaultAuth c. Add a description d. Add phone and email e. Add custom attributes. f. Assign user to a group Any help is appreciated Regards, Cameron ... View more

Hi All, Does anyone know/have a list of all sas keywords for base datastep/procs? I am building a parser for the sas language that color codes sas programs for viewing through a web browser. Many thanks if anyone/SAS can help. Cameron ... View more

Hi, In Base SAS and EG you can set abbreviations to create something similar to Microsoft's Intelli-sense. Is there a way to export abbreviations that you create to another installation of EG / Base SAS? I can see massive value in my organisation with this especially with macros etc. Thanks in advance. ... View more

Hi All, I have some code where I parse a .sas file into a data set. I then apply some recoding rules to flag whether it is the start of a statement, the input dataset, the output dataset etc. I am using this as a basis to develop a code documentation tool. What I want to do is to combine the rows of code that I parse into rows back into a field based on the code block (ie: I want line 1 which has 'Proc printto log=mylog new;' and line 2 'run;' to become field 1 in a new table. I wrote the following code to do this. combining is based on a col called start_pos which is a number relating to the data step/proc statement; %macro getcode(n); proc sql noprint; select progtext into: strVar separated by ';' from progparse2 where start_pos =&n; run; %mend; data testCallExecute; set progparse2(keep=start_pos code_block); format code_block $500.; call execute("%getcode("||start_pos||");"); code_block="&strVar"; run; I have tried the above code either referencing progparse2 via set and also an array looping through each line. What I get in the output dataset is the first combined data step for each step. ie: the call execute statement does not execute the %getcode macro based on the set dataset value of start_pos. It will always return the first combined value. This has me stumped. Any help is appreciated and if this does not make sense just let me know. ... View more

Hi all, I have some stored processes set up to run through a url display portlet in the Info Delivery Portal. I have taken the url as; https:// :8080/SASStoredProcess/etc What I have found however is that on initial loading of the page in the Info Portal, the user is given a challenge prompt for the user's credentials. Is there a parameter that I can add to the querystring of the stored process to stop this? ... View more