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?
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.
April 27 - 30 | GAYLORD TEXAN
Register now to lock in early bird pricing through February 25!
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.
Ready to level-up your skills? Choose your own adventure.
Browse our catalog!