DATA Step, Macro, Functions and more

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

Reply
N/A
Posts: 0

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

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
Super Contributor
Super Contributor
Posts: 3,174

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

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
Ask a Question
Discussion stats
  • 1 reply
  • 119 views
  • 0 likes
  • 2 in conversation