I don't use VIEWTABLE either (for several reasons). I've noticed, with the "mixed" date values it writes error messages to the log (in black color!), one for each invalid value:
ERROR: There was a problem with the format so BEST. was used.
So, the table itself shows a mixture of BEST. and DATE9. formatted values, as shown in @vraj1's screenshot.
Hi,
Is it possible with SAS to read a date from Oracle Database and write it out as format shown below.
30Apr2016:00:00:00
Thanks
Hi,
Please don't reopen old posts which have been closed. You have a post here:
About this.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.