BookmarkSubscribeRSS Feed
Steelers_In_DC
Barite | Level 11

I am trying to search for a specific datestamp and not sure what the correct syntax is using proc sql, to be more precise I'm pulling data from netezza using sas.  I want to find the following:

where ETL_PRCS_START_TS = 23AUG2012:16:58:12.000000

Is there an easy way to format that date?

1 REPLY 1
Steelers_In_DC
Barite | Level 11

I should say that the following works:

WHERE ETL_PRCS_START_TS = '23AUG2012:16:58:12.000000'dt

but I'm working within netezza, I think this should be a question posted to another forum.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

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
  • 1 reply
  • 503 views
  • 0 likes
  • 1 in conversation