Hi Everyone, is there a suitable SAS timestamp INFORMAT, which can process a 26 character long timestamp value which includes 6 decimal places? I only found the ANYDTDTM INFORMAT. But using this informat, the six decimal places are truncated and set to zero.   data have; length ts_alphanumeric $26.; ts_alphanumeric = "2021-10-17-20.00.05.571907"; ts_notyet = input(ts_alphanumeric, ANYDTDTM.); format ts_notyet datetime25.6; run; What I want, is this: data want; ts_want = dhms("17OCT2021"d, 20,00,05.571907) ; format ts_want datetime25.6; run; I'd prefer an informat rather than use dateime functions like "dhms", "datepart", etc.   Any suggestions?   Cheers, FK1 ... View more

Hi Everyone,   I want to get the "last modified" timestamp of a file residing in a AIX filesytem.   When I use this AIX-command: istat SASWebReportStudio4.4_KeyActions.log | grep modified | awk '{print $3, $4, $5, $6, $7, $8}' I get this output: Wed Jun 16 17:35:28 CEST 2021 Can someone tell me, how the heck I can get this into a decent SAS timestamp?   Thx     ... View more

Hello Everyone,   I want to execute multiple OS commands out of my EG Session, using the OS root-User. Having found this wonderful Filename pipe  approach, I generated this code:     %LET l_rm_cmd = %nrbquote(%str(sudo su -; whoami ; rm -f /home/enp2sas/mh.w.jum0080.01 /home/enp2sas/ok.jum0080.01;echo STATUS=$?;)); %PUT &=l_rm_cmd; filename oscmd pipe "&l_rm_cmd "; %let SYsrc=0; %put INFO: &=SYSRC; data _null_ ; infile oscmd; input @; put _infile_; if _infile_ eq: 'STATUS' then do; input status=; putlog 'INFO: ' status=; call symputx('SYSRC',status); end; run; %put INFO: &=SYSRC;     This is the corresponding Log: NOTE: The infile OSCMD is: Pipe command="sudo su -; whoami ; rm -f /home/enp2sas/mh.w.jum0080.01 /home/enp2sas/ok.jum0080.01;echo STATUS=$?; " [YOU HAVE NEW MAIL] sas rm: 0653-609 Cannot remove /home/enp2sas/mh.w.jum0080.01. The file access permissions do not allow the specified action. rm: 0653-609 Cannot remove /home/enp2sas/ok.jum0080.01. The file access permissions do not allow the specified action. STATUS=2 INFO: status=2   In the "background" my EG Userprofile is "mapped" to the OS user "sas", therefore, the Log of this code shows me as a result of the OS "whoami" command that the OS commands are executed with the User "sas". I was expecting "root" however, as my first command is "sudo su -".   Are these chained commands executed in multiple (KORN) shells, so that the second OS command (i.e. "whoami") is being executed in a different shell, than the "sudo su -" command in front of it?   The reason, why I need to change, is exactly the two error message of the "rm" command, as the "sas" User does not have the neccessary privileges to remove the two files.   What confuses me even more is, that the execution of these commands directly in a shell with the User "sas" is working fine, without any errors.   Can someone explain to me what the difference is between executing OS commands from within EG versus directly in a shell? Why is it not possible to sudo su to root from within a EG session?   ... View more

Hello! I want to create the timestamp "31DEC9999:23:59:59.999999" with this code:   data _NULL_; without_decimals = dhms('31DEC9999'D,23,59,59); with_decimals = sum(dhms('31DEC9999'D,23,59,59) , 0.999999 ); put without_decimals= datetime25.6; put with_decimals = datetime25.6; run; However, in the Log I get this:   without_decimals=31DEC9999:23:59:59.000000 with_decimals=01JAN****:00:00:00.000000 NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds   Why do I not get the expected "31DEC9999:23:59:59.999999" ?         ... View more