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.
Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.
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!