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
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.