https://communities.sas.com/t5/SAS-Programming/how-to-assign-the-results-of-a-query-to-a-variable-in-a-sas/m-p/29497#M5555 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.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Suggested Google advanced search arguments, this topic/post:<BR /> proc sql macro variable into site:sas.com<BR /> retain statement macro variable site:sas.com Mon, 31 May 2010 20:25:27 GMT sbb 2010-05-31T20:25:27Z https://communities.sas.com/t5/SAS-Programming/how-to-assign-the-results-of-a-query-to-a-variable-in-a-sas/m-p/29496#M5554 Hi,<BR /> <BR /> 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.<BR /> <BR /> Eg:<BR /> 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.<BR /> <BR /> Kindly let me know how to attain this.<BR /> <BR /> Regards,<BR /> Prashant Mon, 31 May 2010 20:21:24 GMT https://communities.sas.com/t5/SAS-Programming/how-to-assign-the-results-of-a-query-to-a-variable-in-a-sas/m-p/29496#M5554 deleted_user 2010-05-31T20:21:24Z https://communities.sas.com/t5/SAS-Programming/how-to-assign-the-results-of-a-query-to-a-variable-in-a-sas/m-p/29497#M5555 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.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Suggested Google advanced search arguments, this topic/post:<BR /> proc sql macro variable into site:sas.com<BR /> retain statement macro variable site:sas.com Mon, 31 May 2010 20:25:27 GMT https://communities.sas.com/t5/SAS-Programming/how-to-assign-the-results-of-a-query-to-a-variable-in-a-sas/m-p/29497#M5555 sbb 2010-05-31T20:25:27Z