07-24-2014 10:40 AM
I have two separate fields - one a date and one a time - that I need to concatenate together into one long datetime field.
Date field is a numeric field, currently in the YYYY-MM-DD format (2014-07-24 for example) and the time field is numeric in the HH:MMS format (9:23:00 or 11:35:00 for example - the leading 0 is not there for half of the time).
I need to get these two separate fields into a format that looks like: 01NOV13:09:23:00 - the date has a length of 7, the time has a length of 8 and there is a colon between them.
I tried formatting both fields, then concatenating, then formatting the concatenated field, and no such luck.
07-24-2014 11:01 AM
Great - that worked, except that SAS couldn't find the hhmmss format - I changed it to hhmm8. and then it worked like a charm.
I didn't even think about the attrib - have rarely used it.