Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Transform a string to become a datetime value
Thank you, it works fine, I didnt know about the scan function This works : Data _null_ ; %let entry_date_time_orig = "10/13/2007 01:14:35" ; entry_date_time=sum((input(scan(&entry_date_time_orig.,1,' '),mmddyy10.)*60*60*24),input(scan(&entry_date_time_orig.,2,' '),time8.)); put...- ymercier
- Post #4
- Forum: SAS Institute, Inc. solutions
-
FTP - Unix
commands in your script file should still work but you may have to change those lines %sysexec ftp -s:"&script_file"; %sysexec del "&script_file"; by this %sysexec ftp -i < "&script_file"; %sysexec rm "&script_file";- ymercier
- Post #3
- Forum: SAS Institute, Inc. solutions
-
Transform a string to become a datetime value
I have a dataset with a string variable that has this appearance : "10/16/2007 22:37:30". I would like to convert this string to become a datetime value. I read that the datetime format is this 16Oct2007:22:37:30 but I was trying to create a date and a time variable from the string using the...- ymercier
- Thread
- Replies: 3
- Forum: SAS Institute, Inc. solutions
