ACTUALLY, your comment on it being somewhere else in the code made me look elsewhere. I had this data joining to another table in a proc sql, and it must have been reverting back to the seconds then. I put a format in the proc sql, and it worked. Thank you, Reeza! ... View more

Yes, that did display correctly: 1 27AUG2015:16:11:05 16:11 As far as I can tell, I don't do any further processing to this particular dataset later on, except to join it up to other tables and output this time field. Is there anything else I should look for to troubleshoot? ... View more

It is an Excel file that is put together via an ods tagsets.excelxp. ... View more

I got it! I was using pass-through logic already, so I looked further into the code to see if there was something I missed. Turns out there was. The issue ended up being some commenting that I had in SQL using the "--" syntax. Since it seems SAS was processing the SQL statement as a block of text (instead of the line-by-line formatting I had), it was including some additional lines in the comment that I was not expecting. I took those parts out, and now it works just fine. Thank you Doc, Mark, and SASKiwi for helping me to get to the bottom of this! ... View more

Thank you, Doc! I am very new to SAS, and I do not believe I have used the pass-thru facility--what do you mean by that? ... View more

The issue came in where I had multiple nested and/or statements in the WHERE clause. This is essentially what the statement in question looks like:     where         x.rownum=1         and((X.nbr_fld=123456 and X.dt_fld>='02-SEP-2014')         or (X.nbr_fld=234567 and X.dt_fld>='02-SEP-2014')         or (X.nbr_fld=345678 and X.dt_fld>='02-SEP-2014')         or (X.nbr_fld=111222 and X.dt_fld>='02-SEP-2014')         or (X.nbr_fld=222333 and X.dt_fld>='02-SEP-2014')         or (X.nbr_fld=123123 and X.dt_fld>='03-SEP-2014')         or (X.nbr_fld=321321 and X.dt_fld>='03-SEP-2014')         or (X.nbr_fld=432432 and X.dt_fld>='03-SEP-2014') ..... ) Because of the nature of the data I am working with, I have a number of these clauses (745, to be exact). Also, each date is particular to each serial number, so I am not sure if I could "hard code" any of these dates. ... View more

Got it--that worked! I was trying to use just "style" instead of "style(column)"--once I changed that, it worked perfectly. Thank you to both of you--I really appreciate it! ... View more

Thank you, Tom--that worked perfectly for my proc print statements. I am only having difficulty with a proc report--it does not seem that tagattr is an option for that--is there a way to do the same thing in a proc report? Thanks again! ... View more