Quick question. I searched online, but it seems SAS does not have a time format to omit the colon. I am in the middle of a program compiling a ton of logs; some are in 24 hour format, some are in 12 hour. The database I upload it to requires it be in HHMM - no colons, and exactly 4 characters.
I got it to 24 hour. Easy. 9:34am is now 9:34. However, I can't figure out how to get it to 0934. Any advice? Or should I use a PROC SQL statement?
Thank you both! Curtis, that format picture worked perfectly!
I have another question now... I am trying to get the date in ISO 8601 format (YYYYMMDD). SAS calls this B8601DAw. as the output informat. However, there is no similar output format. The date in the worksheet is in MM/DD/YY format, and I have that properly selected, but SAS just errors out and says "NOTE: Invalid data for date in line 133 136-143." many times over throughout the file.
I'm sure this is a really simple solution... Does anybody have a recommendation for a good book for newbies? I'm sure I could get my company to buy one for me... I just need a good primer.
I think of informats being for input rather than output, so I find this posting a bit confusing.
For input use informat YYMMDD8. and for output read the doc for YYMMDDx. When x=N you get no delimiters.