Hey, You can use function datepart to extract the date. You can use functions month & day to extract month & day information. You can use function mdy to construct the date "format" and you can use dhms to reconstruct the datetime format. /* example code */ data _null_; x = "12NOV1935:00:00:00"dt; datepart = datepart(x); put x; put datepart date9.; mon = month(datepart); day = day(datepart); put mon=; put day=; mdyt = dhms(mdy(mon,day,2012),0,0,0); put mdyt datetime18.; run; More information about aformentioned functions can be found at Functions and CALL Routines (http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000245852.htm ). Kind regards, Bago ... View more

Hey, The FILENAME function executes during DATA step execution, while the FILE statement opens the file before the DATA step begins execution. If you use the FILENAME in the DATA step, the DATA step compiles both the FILENAME function and FILE statement. At this point, no files have been created. Just before the DATA step executes, the fileref StatFile is opened for output (created). The fileref StatFile doesn't exist, so a file named StatFile.dat is created. When the DATA step executes, the FILENAME function executes and creates the fileref StatFile. At this point, it is too late to use this fileref with the FILE statement as the FILE statement has already done its work. Hope this helps, Bago ... View more

Hey, You could use a datastep to retrieve the users registered in the metadata e.g. : /* example */ /* connect to metadataserver */ options metaserver=""                   /* specify metadataserver */   metaport=8561                             /* metadata server port */ metauser=""                                 /* user id : e.g. SAS Administrator --> sasadm */ metapass=""                   /* user password          */ metarepository="Foundation" metaprotocol=BRIDGE; /* retrieve list of users */ data _null_;   length uri $256 user $100;   nobj=1;   n=1;   do while(nobj >= 0);   nobj=metadata_getnobj("omsobj:Person?@Id contains '.'",n,uri);       if (nobj < 0) then leave;       arc=metadata_getattr(uri,"Name",user);      put n= user=;      n=n+1;   end; run; /* end example */ If you want to create a list containing groups change Person by IdentityGroup. If you want to create a list containing both groups and users change Person by Identity. Instead of writing the user information to the log you can write it to a dataset. You can use this dataset to create reports. Besides retrieving the name of the users you can extract extra information from the metadata such as when the user was created. To know this you would retrieve information about the inherited attibute "MetadataCreated" (http://support.sas.com/documentation/cdl/en/omamodref/61849/HTML/default/viewer.htm#person.htm ) e.g. arc=metadata_getattr(uri,"MetadataCreated",MC); FYI : SAS ® 9.1.3 Open Metadata Interface : http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_913/omd_ref_10177.pdf Regards, Bago ... View more