I am new to SAS programming. I have a requirement where i need to get the result of a SQL query into a variable and use it in another data step later for validation.
I get the Current YEAR as the RESULT of my query. I need to use this date to validate the accounts that needs to be loaded to the final dattabase. I will be using "if" condition in the datablock to validate this.
You can use PROC SQL and generate a SAS macro variable based on your data criteria. Then in the subsequent DATA step, you can reference this macro variable in one of several ways - likely as a data-constant or possibly as a RETAIN statement variable -- note that either choice must be wrapped in double-quotes, not single-quotes.
Suggested Google advanced search arguments, this topic/post:
proc sql macro variable into site:sas.com
retain statement macro variable site:sas.com