I recently came across this question in a Discussion and i was not able to provide a solution. the Macro variable is created by concatenating as shown below i am not sure how do i use the series macro variables created, and it would not be wise idea to resolve all the macro variables created by using %put statement. I feel i missed something very basic thing here.   Query: To produce a series of macro variables named “outxx” where xx is different for each value of “ID” found in step b. This series of macro variables much contain the number of records for each value found in step b.   Can anybody suggest me on this?   data test0; do x=1 to 7; ID='DEF00001'; output; end; do x=1 to 3; ID='GHI00002'; output; end; do x=1 to 5; ID='ABC00001'; output; end; run;   proc sort data=test0 out=test1; BY ID; run; data test2; retain num_rows num_vals 0; set test1; BY ID; if first.ID then num_rows=0; num_rows=num_rows+1; if last.ID then do; num_vals=num_vals+1; call symput('OUT'|| strip(put(num_vals,6.0)),strip(put(num_rows,6.0))); output; end; run; %PUT &=====>>Out1 ; ... View more

Hi,   i need to suppress the warning messages, from the SAS logs for the completion of Auto-sys jobs.  i got to know that we can wrap the code, and then suppress the logs. as i am not sure of the wrapping of SAS code. Do we have any options to suppress the Warning messages from the logs or if any of the experts on the board give me an example or any article related to wrap a SAS code.   Regards, Santtosh...  ... View more

Hi All,     I need to Add or update email addresses for users on Metadata, I have more than 100 emails to be updated and this request comes  frequently and i spend a lot of time updating the Email type and the Email addresses. Could you please suggest, how this can be done by using a Macro or a program?   I have used proc metadata to register a table.   Thank you!!! Regards S..... ... View more

Hi All,   I am trying to read SAS ECM log file in order to capture the login and logoff time. I was successful to read the SAS ECM log file using a sas data step. But I am not sure why I am not able to capture all the events from the log file into SAS dataset. Only the members of a certain group are captured in the dataset.   I am using the below code to read the log file and process it further.   /* Determine list of files to analyze */  %let start_dt=01JAN2018;  /* %let log_path=/tmp/logs_workarea/xxxServer8_1;*/  /* %let log_path=/workspace/wfeaa/sasdata/xxx/logs/;*/  %let log_path=/workspace/wfeaa/sasdata/xxx/logs/midtier_replica;  filename flist pipe "ls &log_path.";  data step01(keep=fpath);   length fname $255;   infile flist;   input fname $;   last_word=input(scan(fname,-1,'.'),yymmdd10.);   fpath="&log_path./"||fname;   if last_word= '.' or last_word ge "&start_dt."d then    output;  run;  /* Get relevant records from log files */  data _null_;   set step01;   call execute    ("    filename logrecs pipe 'more "||fpath||" | grep com.sas.solutions.casemgmt.util.AppSessionContext';    data step02;    length instr $1000;    infile logrecs lrecl=1000 dlm='7F'x missover truncover dsd;    input instr $;    if find(instr,'INFO') then output;     run;    proc append base=step03 data=step02;    run;");  run;  proc sql;   create table step04 as    select instr, name, displayname     from step03      left join person on instr contains displayname       having displayname ne '';  quit;  /* Analyze log files */  DATA WORK.INPUT_L (DROP=  instr DT dt1);   set step04;   IF (FIND(instr, '- Creating session context for user,')) GE 1 THEN    DO;     DT=Substr(instr,21,16);     Login_tme=input(DT,anydtdtm23.);     FORMAT Login_tme DateTime23.;    END;   IF (FIND(instr, 'Clearing session context for user')) GE 1 THEN    DO;     DT1=Substr(instr,21,16);     LogOff_tme=input(DT1,anydtdtm23.);     Format LogOff_tme DateTime23.;    END;  RUN;   Please help me on this. I am not able to read all the users who have logged in to SAS ECM.   ... View more

Hi All,   I am trying to capture the Environment where the Current SAS program is executing. for EX: if the SAS program is executing in Dev environment need to capture this in a macro variable. %if  env = 10.09.126.4 %then do; %let Env = Dev ; %end; %else %do; %let env = Prod; %end;   I want know if we have any Auto macro variables which displays the Environment the SAS code is running.   Thanks             ... View more

Hi,   I am trying to extract details of the users from Groups. The details I am looking to extract are  1. User name 2. user email 3 name of the group  I have tried using the below mentioned,      /* Use the META* options to specify the options for connecting to the */    /* metadata server that contains the user information. */ options metaserver=zzzzzzzz123456.xxxxxbe.com                                                  metaport=8561                       metauser="metaxxxxxxxx"                                                metapass="xxxxxxxxxxxx"                    /*metaprotocol=bridge*/          metarepository=Foundation;   data users_grps;    length uri name group groupuri $256 id $20;          /* Initialize variables to missing. */    n=1;    uri='';    name='';    group='';    groupuri='';    id='';          /* Determine how many person objects are defined. */    nobj=metadata_getnobj("omsobj:Person?@Id contains '.'",n,uri);    if nobj=0 then put 'No Persons available.';    else do while (nobj > 0);          /* Retrieve the current person's name. */       rc=metadata_getattr(uri, "Name", Name);   /* Get the group association information for the current person. */       a=1;       grpassn=metadata_getnasn(uri,"IdentityGroups",a,groupuri);                /* If this person does not belong to any groups, set their group */          /* variable to 'No groups' and output the name. */       if grpassn in (-3,-4) then do;          group="No groups";          output;       end;          /* If the person belongs to any groups, loop through the list */          /* and retrieve the name of each group, outputting each on a */          /* separate record. */       else do while (grpassn > 0);          rc2=metadata_getattr(groupuri, "Name", group);          a+1;          output;          grpassn=metadata_getnasn(uri,"IdentityGroups",a,groupuri);       end;              /* Retrieve the next person's information. */       n+1;       nobj=metadata_getnobj("omsobj:Person?@Id contains '.'",n,uri);    end;   keep name group; run;   This only gives me details of the group to which the user is a member of.     Regards, S ... View more