BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
FreelanceReinh
Jade | Level 19

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.

moetimollo
Calcite | Level 5

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

RW9
Diamond | Level 26 RW9
Diamond | Level 26

Hi,

 

Please don't reopen old posts which have been closed.  You have a post here:

https://communities.sas.com/t5/General-SAS-Programming/Date-format-with-the-specific-format-30Apr201...

About this.

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 17 replies
  • 7299 views
  • 0 likes
  • 7 in conversation