how to assign the results of a query to a variable in a sas program

[deleted_user]

Hi,

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.

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

Kindly let me know how to attain this.

Regards,
Prashant

[sbb]

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.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search arguments, this topic/post:
proc sql macro variable into site:sas.com
retain statement macro variable site:sas.com