Does this code works for single tier windows environment with just sas foundation and sas eg connects locally with no sas bi platform. I ran the code but with 0 records. actually am looking for a code which can give list of all active users using sas (base sas/sas eg ) in our environment.     below is the log     1 The SAS System 13:27 Monday, June 3, 2019 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTNAME=''; 7 %LET _SASPROGRAMFILE=; 8 9 ODS _ALL_ CLOSE; 10 OPTIONS DEV=PNG; 11 GOPTIONS XPIXELS=0 YPIXELS=0; 12 FILENAME EGSR TEMP; 13 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 14 STYLE=HtmlBlue 15 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css") 16 NOGTITLE 17 NOGFOOTNOTE 18 GPATH=&sasworklocation 19 ENCODING=UTF8 20 options(rolap="on") 21 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 22 23 GOPTIONS ACCESSIBLE; 24 data users_grps; 25 26 /* The LENGTH statement defines variables for function arguments and 27 assigns the maximum length of each variable. */ 28 29 length uri name dispname group groupuri $256 30 id MDUpdate $20; 31 32 /* The CALL MISSING routine initializes output variables to missing values.*/ 33 34 n=1; 35 call missing(uri, name, dispname, group, groupuri, id, MDUpdate); 36 37 38 /* The METADATA_GETNOBJ function specifies to get the Person objects 39 in the repository. The n argument specifies to get the first Person object that is 40 returned. The uri argument will return the actual uri of the Person object that 41 is returned. The program prints an informational message if no Person objects 42 are found. */ 43 44 nobj=metadata_getnobj("omsobj:Person?@Id contains '.'",n,uri); 45 if nobj=0 then put 'No Persons available.'; 46 47 /* The DO statement specifies a group of statements to be executed as a unit 48 for the Person object that is returned by METADATA_GETNOBJ. The METADATA_GETATTR 49 function gets the values of the object's Name and DisplayName attributes. */ 50 51 else do while (nobj > 0); 52 rc=metadata_getattr(uri, "Name", Name); 53 rc=metadata_getattr(uri, "DisplayName", DispName); 54 55 56 /* The METADATA_GETNASN function gets objects associated via the IdentityGroups 57 association. The a argument specifies to return the first associated object for 2 The SAS System 13:27 Monday, June 3, 2019 58 that association type. The URI of the associated object is returned in the 59 groupuri variable. */ 60 61 a=1; 62 grpassn=metadata_getnasn(uri,"IdentityGroups",a,groupuri); 63 64 /* If a person does not belong to any groups, set their group 65 variable to 'No groups' and output their name. */ 66 67 if grpassn in (-3,-4) then do; 68 group="No groups"; 69 output; 70 end; 71 72 /* If the person belongs to many groups, loop through the list 73 and retrieve the Name and MetadataUpdated attributes of each group, 74 outputting each on a separate record. */ 75 76 else do while (grpassn > 0); 77 rc2=metadata_getattr(groupuri, "Name", group); 78 rc=metadata_getattr(groupuri, "MetadataUpdated", MDUpdate); 79 a+1; 80 output; 81 grpassn=metadata_getnasn(uri,"IdentityGroups",a,groupuri); 82 end; 83 84 /* Retrieve the next person's information */ 85 86 n+1; 87 nobj=metadata_getnobj("omsobj:Person?@Id contains '.'",n,uri); 88 end; 89 90 /* The KEEP statement specifies the variables to include in the output data set. */ 91 92 keep name dispname MDUpdate group; 93 run; NOTE: The data set WORK.USERS_GRPS has 0 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.15 seconds cpu time 0.04 seconds 94 95 /* Display the list of users and their groups */ 96 proc report data=users_grps nowd headline headskip; 97 columns name dispname group MDUpdate; 98 define name / order 'User Name' format=$30.; 99 define dispname / order 'Display Name' format=$30.; 100 define group / order 'Group' format=$30.; 101 define MDUpdate / display 'Updated' format=$20.; 102 break after name / skip; 103 run; NOTE: No observations in data set WORK.USERS_GRPS. NOTE: No observations in input data set. NOTE: PROCEDURE REPORT used (Total process time): real time 0.12 seconds 3 The SAS System 13:27 Monday, June 3, 2019 cpu time 0.04 seconds 104 105 GOPTIONS NOACCESSIBLE; 106 %LET _CLIENTTASKLABEL=; 107 %LET _CLIENTPROCESSFLOWNAME=; 108 %LET _CLIENTPROJECTPATH=; 109 %LET _CLIENTPROJECTNAME=; 110 %LET _SASPROGRAMFILE=; 111 112 ;*';*";*/;quit;run; 113 ODS _ALL_ CLOSE; 114 115 116 QUIT; RUN; 117 ... View more

Could you please be more clear about the physical path, which data physical path file you are saying to declare. fyi ours is just basic sas foundation environment with sas eg connects locally to foundation. we dont have any sas bi platform. so i want to know which are all the user actively using base sas and sas eg. btw we have only one 9.4 version.     %let infile1= \c:\xxxx\xxxx/xxxxx;   ( which phyical path i need to declare here ) ... View more

Below is the log, I dont see error or any info that would be helpful     1 The SAS System 13:26 Sunday, June 2, 2019 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=PNG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 FILENAME EGSR TEMP; 15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 16 STYLE=HtmlBlue 17 STYLESHEET=(URL="file:///F:/app/SAS94/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css") 18 NOGTITLE 19 NOGFOOTNOTE 20 GPATH=&sasworklocation 21 ENCODING=UTF8 22 options(rolap="on") 23 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 24 25 GOPTIONS ACCESSIBLE; 26 filename in "&infile1" recfm=v lrecl=512; WARNING: Apparent symbolic reference INFILE1 not resolved. 27 28 %macro read_spawnlog; 29 data spawnlog; 30 infile in truncover; 31 format 32 datum ddmmyyp10. 33 zeit time8. 34 user $8. 35 port $4. 36 address $15. 37 success $1. 38 ; 39 input 40 zeile $512. 41 ; 42 if index(zeile,"New client connection") > 0; 43 %if "&sysver" = "9.4" 44 %then %do; 45 datum = input(substr(zeile,1,10),yymmdd10.); 46 zeit = input(substr(zeile,12,8),time8.); 47 %end; 48 %else %if "&sysver" = "9.2" 49 %then %do; 50 datum = input(substr(zeile,1,10),yymmdd10.); 51 zeit = input(substr(zeile,12,8),time8.); 52 %end; 53 %else %if "&sysver" = "9.1" 54 %then %do; 55 datum = input(substr(zeile,1,8),yymmdd8.); 56 zeit = input(substr(zeile,10,8),time8.); 2 The SAS System 13:26 Sunday, June 2, 2019 57 %end; 58 %else %do; 59 abort abend 7; 60 %end; 61 pos = index(zeile,"server port"); 62 port = substr(zeile,pos+12,4); 63 pos = index(zeile,"for user"); 64 if pos ne 0 65 then do; 66 user = substr(zeile,pos+9,5); 67 pos = indexc(user,"."); 68 if pos ne 0 then user = substr(user,1,pos-1); 69 end; 70 else do; 71 pos = index(zeile,"for SAS token user"); 72 user = substr(zeile,pos+19); 73 pos = indexc(user,"@"); 74 if pos ne 0 then user = substr(user,1,pos-1); 75 end; 76 pos = index(zeile,"port are"); 77 %if "&sysver" = "9.4" 78 %then %do; 79 address = substr(zeile,pos+17,15); 80 pos = indexc(address,"]"); 81 if pos > 0 then address = substr(address,1,pos-1); 82 %end; 83 %else %if "&sysver" = "9.2" 84 %then %do; 85 address = substr(zeile,pos+17,15); 86 pos = indexc(address,"]"); 87 if pos > 0 then address = substr(address,1,pos-1); 88 %end; 89 %else %do; 90 address = substr(zeile,pos+9,15); 91 pos = indexc(address,":"); 92 if pos > 0 then address = substr(address,1,pos-1); 93 %end; 94 if index(zeile,"rejected") > 0 then success = "N"; else success = "J"; 95 drop zeile pos; 96 run; 97 %mend; 98 99 GOPTIONS NOACCESSIBLE; 100 %LET _CLIENTTASKLABEL=; 101 %LET _CLIENTPROCESSFLOWNAME=; 102 %LET _CLIENTPROJECTPATH=; 103 %LET _CLIENTPROJECTPATHHOST=; 104 %LET _CLIENTPROJECTNAME=; 105 %LET _SASPROGRAMFILE=; 106 %LET _SASPROGRAMFILEHOST=; 107 108 ;*';*";*/;quit;run; 109 ODS _ALL_ CLOSE; 110 111 112 QUIT; RUN; 113 ... View more

Hi Kurtbremser   Am looking for a way to find the list of active users accessing or using PC SAS/SAS Studio/SAS EG in our environment, The code which you posted back in Nov 2018, I tried to run it from SAS Studio and SAS EG (connects locally), but It didn't not give any output nor any error.does this code works or do I need to make any changes to this code in order to make it work.   your help here would be really appreciated. ... View more